There are four main ranking functions in SQL: ROW_NUMBER ... For example, you can use this query to select the top 10 best-selling products by category: SELECT category, product, sales, ROW ...

INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw ... The following example shows the four ranking functions used in the same query. For function-specific examples, see each ranking function.

RANK() Assigns a unique rank to each row based on the specified order. If there are duplicate values, it skips ranks for subsequent rows. The ranking sequence contains gaps after duplicate ranks.