SQL Editor

SQL Ntile Example Example

Task:

List all products with prices between $1 and $10.
Group the list into four equal parts (i.e. quartiles).
Click here for details on NTILE.
 
 15 Records
ProductName UnitPrice Quartile
Geitost 2.50 1
Guaraná Fantástica 4.50 1
Konbu 6.00 1
Filo Mix 7.00 1
Tourtière 7.45 2
Rhönbräu Klosterbier 7.75 2
Tunnbröd 9.00 2
Teatime Chocolate Biscuits 9.20 2
Rogede sild 9.50 3
Zaanse koeken 9.50 3
Jack's New England Clam Chowder 9.65 3
Stroopwafels 9.75 3
Longlife Tofu 10.00 4
Sir Rodney's Scones 10.00 4
Aniseed Syrup 10.00 4
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.