← 🗃️ SQL Deep Dive19 / 25
Lesson 19 — Ranking with a subquery
Position rows
Count how many rows are larger to compute a rank without window functions.
Why it matters: leaderboards need ranks.
Task
Print each product with how many are pricier.
Keep going with SQL Deep Dive
Ready for more? These paid resources pick up where this lesson leaves off.
UdemyBestsellers
Top-rated SQL Deep Dive courses
Project-based SQL Deep Dive video courses — the perfect paid next step after these free lessons.
Browse on Udemy →AmazonReader picks
Best SQL Deep Dive books
Hand-picked SQL Deep Dive books to master the fundamentals offline.
See on Amazon →Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.