Limit Top Results — Solution & ExplanationProblems / Limit Top Results / EditorialApproachCombining ORDER BY with LIMIT is the standard pattern for "top N" queries.

ORDER BY score DESC puts the highest scores first.

LIMIT 5 truncates to only the first 5 rows.

Always sort before limiting — LIMIT without ORDER BY returns arbitrary rows.Hints

First sort the rows so the highest scores come first, then limit.

LIMIT goes after ORDER BY in SQL.

In PySpark, use .limit(n) after .orderBy().

Solve Limit Top Results yourself →