Figure 4: SQL Server 2000 NTILE(8) query result
orderid qty rownum ntile8
30001 10 1 1
10001 10 2 1
10006 10 3 2
40005 10 4 2
30003 15 5 3
30004 20 6 3
20002 20 7 4
20001 20 8 5
10005 30 9 6
30007 30 10 7
40001 40 11 8