EXPLAIN EXTENDED

How to create fast database queries

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 »

Written by Quassnoi

March 9th, 2009 at 11:00 pm

Posted in MySQL