Task:

List products sorted by price. Rank each row.
Click here for details on DENSE_RANK.
 
 77 Records
ProductName UnitPrice Rank
Geitost 25.09 1
Guaraná Fantástica 53.64 2
Konbu 71.49 3
Filo Mix 90.39 4
Tourtière 96.15 5
Rhönbräu Klosterbier 100.06 6
Longlife Tofu 116.57 7
Aniseed Syrup 116.57 7
Sir Rodney's Scones 116.57 7
Tunnbröd 125.80 8
Teatime Chocolate Biscuits 128.57 9
Zaanse koeken 132.81 10
Rogede sild 132.81 10
Jack's New England Clam Chowder 134.92 11
Spegesild 139.85 12
Scottish Longbreads 145.68 13
Gorgonzola Telino 145.68 13
Chocolade 148.53 14
Original Frankfurter grüne Soße 151.50 15
Escargots de Bourgogne 154.43 16
Laughing Lumberjack Lager 163.09 17
Singaporean Hokkien Fried Mee 163.09 17
Sasquatch Ale 163.09 17
NuNuCa Nuß-Nougat-Creme 163.09 17
Röd Kaviar 174.86 18
Outback Lager 174.86 18
Genen Shouyu 180.64 19
Valkoinen suklaa 189.39 20
Louisiana Hot Spiced Okra 198.17 21
Pavlova 203.32 22
chai_new2 209.65 23
Steeleye Stout 209.65 23
Chartreuse verte 209.65 23
Lakkalikööri 209.65 23
Boston Crab Meat 214.38 24
Inlagd Sill 221.30 25
Chang 221.30 25
Gula Malacca 226.63 26
Ravioli Angelo 227.18 27
Maxilaku 232.94 28
Queso Cabrales 244.63 29
Gustaf's Knäckebröd 244.63 29
Louisiana Fiery Hot Pepper Sauce 245.19 30
Chef Anton's Gumbo Mix 248.72 31
Flotemysost 250.37 32
Chef Anton's Cajun Seasoning 256.22 33
Tofu 270.91 34
Pâté chinois 279.61 35
Grandma's Boysenberry Spread 291.23 36
Nord-Ost Matjeshering 301.64 37
Gravad lax 302.90 38
Sirop d'érable 331.99 39
Uncle Bob's Organic Dried Pears 349.47 40
Ikura 361.17 41
Gumbär Gummibärchen 363.87 42
Mascarpone Fabioli 372.78 43
Perth Pasties 382.07 44
Wimmers gute Semmelknödel 387.35 45
Camembert Pierrot 396.07 46
Mozzarella di Giovanni 405.36 47
Gudbrandsdalsost 419.38 48
Gnocchi di nonna Alice 442.71 49
Queso Manchego La Pastora 442.71 49
Alice Mutton 454.37 50
Northwoods Cranberry Sauce 465.94 51
Schoggi Schokolade 511.42 52
Vegie-spread 511.42 52
Rössle Sauerkraut 531.17 53
Ipoh Coffee 535.82 54
Tarte au sucre 574.29 55
Manjimup Dried Apples 617.35 56
Raclette Courdavault 640.74 57
Carnarvon Tigers 728.07 58
Sir Rodney's Marmalade 943.59 59
Thüringer Rostbratwurst 961.37 60
Mishi Kobe Niku 1129.96 61
Côte de Blaye 2046.22 62
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