QUERY: - ROW_NUMBER ( ) OVER (order_by_clause) from tbName;

EXAMPLE: - SELECT * ,row_number() OVER (order by grade desc) as Row_Num

FROM customer;

WITH PARTITION BY CLAUSE:-

QUERY: - ROW_NUMBER ( ) OVER ([PARTITION BY value_expression , .. [ n ]]

order_by_clause) from tbName

• OVER([partition_by_clause]order_by_clause)
• partition_by_clause divides the result set produced by the FROM clause into partitions to which the function is applied. If not specified, the function treats all rows of the query result set as a single group. Order_by_clause determines the order of the data before the function is applied. The order_by_clause is required. The <rows or range clause/> of the OVER clause cannot be specified for the RANK function. For more information, see OVER Clause (Transact-SQL).

EXAMPLE: - SELECT * ,row_number() OVER (partition by city order by grade

desc) as Row_Num FROM customer