Use of Dense_Rank() function in SQL Server

No.of Views	:	1049
Bookmarked	:	1 times
Downloads	:
Votes	:	0

By youngmurukan On 15 Feb 2010 21:02:15

Tag : Sql Servers , T-SQL

Skill Level: Intermediate

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

SELECT Dense_Rank() OVER (ORDER BY receiptdate ) as Firt_Arrival,locationnumber,receiptdate
FROM inventorylocsubdetail

Here Dense_Rank() fn would return the rank based on the ReceiptDate. But this would be in sequence even if there are same rank more than one. (This is the major different between Rank() and Dense_Rank())

E.g: here rank 4 repeating for three records,though next rank is 5 (4,4,4,5)

About Author

youngmurukan

Occupation	-	Not Provided
Company	-	Not Provided
Member Type	-	Senior
Location	-	Not Provided
Joined date	-	12 May 2009
Home Page	-	Not Provided
Blog Page	-	Not Provided


Other popularSectionarticles
How to use Partition Analytical Function in SQL How to use Partition Analytical Function in SQL Published Date : 15/Feb/2010 Use of Rank() function in SQL Server Use of Rank() function in SQL Server Published Date : 15/Feb/2010 How to Get First,Last and No of Days in Month Using T-Sql I have read few questions in forums, about how to select first, last date month and how many days in a month. In my project had used some query to perform these tasks. I will share those with article. Published Date : 17/Dec/2010 How to select random records in SQl Server How to select random records in SQl Server Published Date : 15/Feb/2010 how to get how many records entered in day by a user in sql server. how to get how many records entered in day by a user in sql server. Published Date : 15/Feb/2010

Comments

There is no comments for this articles.