Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,359 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 | 13,784 reads
   Items 1 to 2 of 2   
 
Tags
deduplicate (1)    
dense_rank() (1)    
ntile (1)