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

Content with tag Ranking Functions Rss

   Items 1 to 10 of 10   
 

NTILE

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

RANK - 1

By bitbucket-25253 2013/01/07 | Category: ranking functions
Rating: (not yet rated) |  Discuss |   Briefcase | 2,051 reads

SQL Server Ranking Functions

SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.  Read more...
By Additional Articles 2012/03/20 | Source: Database Journal | Category: ranking functions
Rating:  Rate this |   Briefcase | 3,455 reads

Using OVER with an Aggregate Function

By Nakul Vachhrajani 2010/11/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,157 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,362 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,824 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 | 3,906 reads

SqlCredit – Part 19: Exploring SQL 2005’s Ranking Functions – RANK() and DENSE_RANK()

Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.  Read more...
By Additional Articles 2008/10/06 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 3,327 reads

How to use ranking functions in SQL Server 2005

With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions.  Read more...
By Additional Articles 2008/07/22 | Source: SearchSQLServer | Category: ranking functions
Rating:  Rate this |   Briefcase | 4,900 reads
   Items 1 to 10 of 10   
 
Tags
t-sql (9)    
ntile (3)    
row_number() (2)    
advanced t-sql (1)    
aggregate function (1)    
aggregates (1)    
analytical function perfroamnce (1)    
deduplicate (1)    
dense_rank() (1)    
ordering (1)    
stairway series (1)