Problem:

List products with prices between $8 and $12. Include four common ranking functions based on price.
Click here for details on ROW_NUMBER.
 
 9 Records
ProductName UnitPrice RowNumber Rank DenseRank Quartile
Tunnbröd 9.00 1 1 1 1
Teatime Chocolate Biscuits 9.20 2 2 2 1
Rogede sild 9.50 3 3 3 1
Zaanse koeken 9.50 4 3 3 2
Jack's New England Clam Chowder 9.65 5 5 4 2
Sir Rodney's Scones 10.00 6 6 5 3
Longlife Tofu 10.00 7 6 5 3
Aniseed Syrup 10.00 8 6 5 4
Spegesild 12.00 9 9 6 4
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0