Articles → SQL SERVER → Rank() Function In SQL Server

Rank() Function In SQL Server

In this article, we will discuss the Rank() function in the SQL server.

Purpose

The RANK() function assigns a unique rank to rows within a result set, based on the values in a specified column or expression. It ranks rows with identical values the same and leaves gaps in the ranking when there are ties.

Syntax

RANK() OVER ( [PARTITION BY <column(s)>] ORDER BY <expression(s)> )

Example

Consider the following table: -

Picture showing the sample table data in sql server

To rank the records based on the quantity, we will write the following query: -

SELECT 
    order_id,
    product_id,
    quantity, price,
    RANK() OVER (ORDER BY quantity DESC) AS SalaryRank
FROM orders;

Output

Posted By -	Karan Gupta

Posted On -	Monday, October 14, 2024

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**