SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, ntile, Ranking Functions Rss

   Items 1 to 3 of 3   


By Kshitij Satpute 2013/08/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,157 reads

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.  Read more...
By Wayne Sheffield 2010/04/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,032 reads

Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()

Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.  Read more...
By Additional Articles 2008/11/06 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 4,229 reads
   Items 1 to 3 of 3   
dense_rank() (1)    
row_number() (1)