Pages

Sunday, September 15, 2013

SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE | Journey to SQL Authority with Pinal Dave

I have not written about this subject for long time, as I strongly believe that Book On Line explains this concept very well. SQL Server 2005 has total of 4 ranking function. Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic. ROW_NUMBER () OVER ([] )… Continue Reading...

Source: SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE | Journey to SQL Authority with Pinal Dave