← 🗃️ SQL Deep Dive
19 / 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.
Not clear enough?
Task
Print each product with how many are pricier.
🧠 Test your knowledge
A quick 3-question quiz on this lesson — instant feedback.
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.