## Articles with tag ROW_NUMBER()

Search for any content tagged row_number()

Items 1 to 15 of 15

### 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,194 reads

### Calculating Stock Returns Using the ROW_NUMBER function and CTEs

In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.   Read more...
By John Ryle 2011/10/18 | Source: SQLServerCentral.com | Category: common table expressions
Rating: |  Discuss |   Briefcase | 5,294 reads

### How to Compare Rows within Partitioned Sets to Find Overlapping Dates

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates  Read more...
By Kevin Wu 2010/10/11 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 5,191 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,194 reads

### 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,256 reads

### Generating a Distinct Delimited List Using XML

Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.  Read more...
By Puja Shah 2010/06/29 | Source: SQLServerCentral.com | Category: for xml path
Rating: |  Discuss |   Briefcase | 7,130 reads

### Paging and Versioning Using ROW_NUMBER()

Paging through results of data, or finding specific sets of data is something that most of us need to do. A new article from Lawrence Moore shows us how we can do this with ROW_NUMBER()  Read more...
By Lawrence Moore 2010/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,289 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,269 reads

### ROW_NUMBER(): An Efficient Alternative to Subqueries

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...
By Francis Rodrigues 2010/01/29 (first published: 2009/05/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 68,116 reads

### Managing Large Data Sets in SQL Server 2005 and 2008

Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.  Read more...
By Zach Mided 2010/01/04 | Source: SQLServerCentral.com | Category: large data sets
Rating: |  Discuss |   Briefcase | 10,373 reads

### ROW_NUMBER(): An efficient alternative to subqueries – Scenario 2

By Francis Rodrigues 2009/05/29 (first published: 2009/05/26) | Source: SQLServerCentral.com | Category: row_number()
Rating: |  Discuss |   Briefcase | 8,033 reads

### ROW_NUMBER(): An efficient alternative to subqueries – Scenario 2

By Francis Rodrigues 2009/05/29 (first published: 2009/05/26) | Source: SQLServerCentral.com | Category: row_number()
Rating: |  Discuss |   Briefcase | 8,033 reads

### ROW_NUMBER(): An Efficient Alternative to Subqueries

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.  Read more...
By Francis Rodrigues 2010/01/29 (first published: 2009/05/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 68,116 reads

### Duplicate Records using SQLCMD

We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.  Read more...
By Renato Buda 2009/04/06 | Source: SQLServerCentral.com | Category: duplicates
Rating: |  Discuss |   Briefcase | 9,240 reads

### Custom Pagination in SQL Server 2005

Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function.  Read more...
By Adam Haines 2009/01/06 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 9,739 reads
Items 1 to 15 of 15