solulubeta
Sign in
SQL / Window functions & CTEs
06.09 · SQL

Price rank inside each aisle

For every product return category, product_name, unit_price and price_rank: its position by price within its own category (1 = most expensive), using DENSE_RANK().

Hard 3 min Pro

This lesson is part of solulu Pro

For every product return category, product_name, unit_price and price_rank: its position by price within its own category (1 = most expensive), using DENSE_RANK().

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 64 of 77 · updated 2026-10-12