Sql how to partition rank

This article is tagged with: Sql how to partition rank and mysql

how to use rank function in sql

BY LOVE SINGH,
Here, name and id is the column name of the table tbltest.
SELECT
name,
RANK () OVER (
ORDER BY id DESC
) price_rank
FROM
tbltest;

sql how to partition rank

SELECT * FROM (
SELECT
product_id,
product_name,
brand_id,
list_price,
RANK () OVER (
PARTITION BY brand_id
ORDER BY list_price DESC
) price_rank
FROM
production.products
) t
WHERE price_rank <= 3;

This article is tagged with: Sql how to partition rank and mysql