I heard in this forum that amongst the Ranking Functions, NTILE(n) does not show any use. Well, i think this is a best fit for paginations in Reporting modules. The same is also possible using ROW_NUMBER, but i said best fit for NTILE(n). Think over it.