Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, PARTITION BY Rss

   Items 1 to 2 of 2   
 

Eliminating Duplicate Rows using The PARTITION BY clause

The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.  Read more...
By Suresh Maganti 2012/03/02 (first published: 2010/09/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,505 reads

Eliminating Duplicate Rows using The PARTITION BY clause

The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.  Read more...
By Suresh Maganti 2012/03/02 (first published: 2010/09/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,505 reads
   Items 1 to 2 of 2   
 
Tags
row_number() (1)