SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Ranking Functions Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (2)    
rank (1)    
   Items 1 to 2 of 2   
 

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 | 2,210 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 | 3,961 reads
   Items 1 to 2 of 2