Department Top Three Salaries

Top-N-per-group with DENSE_RANK is the canonical window function interview question and mirrors real-world leaderboard, tier, and ranking queries used in analytics pipelines.

Enable JavaScript for the full StreamPrep guide.