Top Earners per Department — Solution & ExplanationProblems / Top Earners per Department / EditorialApproachThis problem requires window functions to rank employees within each department.

Window definition: Partition by department, order by salary descending.

ROW_NUMBER(): Assigns a sequential rank within each partition.

Filter: Keep only rows where rank <= 2.

Select & Order: Return the required columns, ordered by department then rank.

Why ROW_NUMBER?ROW_NUMBER() guarantees unique ranks even with ties, which is what we want here — exactly 2 rows per department.Hints

Use ROW_NUMBER() with PARTITION BY department ORDER BY salary DESC.

Filter for rank <= 2 after computing the window function.

In PySpark, use Window.partitionBy(...).orderBy(...).

Solve Top Earners per Department yourself →