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

Content with tags T-SQL, ROW_NUMBER(), Ranking Functions Rss

   Items 1 to 2 of 2   

Using Ranking Functions to Deduplicate Data

This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005   Read more...
By Andy Riley 2010/07/27 | Source: SQLServerCentral.com | Category: deduplicate
Rating: |  Discuss |   Briefcase | 12,409 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
   Items 1 to 2 of 2   
deduplicate (1)    
dense_rank() (1)    
ntile (1)