Breaking News: Grepper is joining You.com. Read the official announcement!

DENSE_RANK() with partition by in sql

Nanu answered on May 3, 2023 Popularity 9/10 Helpfulness 4/10

answer DENSE_RANK() with partition by in sql

DENSE_RANK() with partition by in sql

Comment

SELECT * FROM (
	SELECT
		product_id,
		product_name,
		category_id,
		list_price,
		DENSE_RANK () OVER ( 
			PARTITION BY category_id
			ORDER BY list_price DESC
		) price_rank 
	FROM
		production.products
) t
WHERE price_rank < 3;
Code language: SQL (Structured Query Language) (sql)

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: www.sqlservertutorial.net

Tags: partition-by sql whatever

Link to this answer
Share Copy Link