ROW_NUMBER()

ROW_NUMBER() assigns a unique sequential number to each row.

Syntax

ROW_NUMBER() OVER(ORDER BY column)

The ORDER BY inside OVER() determines the numbering order.

Your Task

Rank all products by price (highest first):

• Show: name, price, row_num
• Use ROW_NUMBER() OVER(ORDER BY price DESC)