RANK « Aggregate Functions « SQL Server / T-SQL Tutorial






9.6.RANK
9.6.1.The RANK() function preserves the ordinal position of the row in the list.
9.6.2.RANK() OVER
9.6.3.Returning Rows by Rank Without Gaps