Archive for March 9th, 2009
Analytic functions: NTILE
Comments enabled. I *really* need your comment
In the previous article we dealt with analytic functions SUM, AVG and ROW_NUMBER().
Now we will try to emulate NTILE.
NTILE(N) is a special function that has no aggregate analog. It divides each grouping set of rows into N subranges, based on ORDER BY clause, and returns the subrange number for each row.
Read the rest of this entry »
Subscribe in a reader