Bird
0
0

Identify the error in this query:

medium📝 Debug Q14 of 15
SQL - Window Functions Fundamentals
Identify the error in this query:
SELECT id, RANK() OVER ORDER BY score FROM players;
AMissing parentheses after OVER and ORDER BY inside them.
BRANK() cannot be used with OVER clause.
CORDER BY should be outside the OVER clause.
DThe query is correct and will run without errors.
Step-by-Step Solution
Solution:

  1. Step 1: Check syntax of RANK() with OVER

    RANK() requires OVER() with parentheses enclosing ORDER BY clause.

  2. Step 2: Identify missing parentheses

    The query misses parentheses after OVER and does not put ORDER BY inside them, causing syntax error.

  3. Final Answer:

    Missing parentheses after OVER and ORDER BY inside them. -> Option A

  4. Quick Check:

    OVER() must have parentheses with ORDER BY inside [OK]
Quick Trick: Always use OVER(...) with parentheses enclosing ORDER BY [OK]
Common Mistakes:
  • Writing OVER without parentheses
  • Placing ORDER BY outside OVER()
  • Assuming RANK() works without OVER

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Why query patterns matter - Quiz 2easy CASE Expressions - Why CASE expressions are needed - Quiz 13medium Common Table Expressions (CTEs) - CTE referencing another CTE - Quiz 6medium Common Table Expressions (CTEs) - Recursive CTE for series generation - Quiz 4medium Database Design and Normalization - Star schema concept - Quiz 5medium Indexes and Query Performance - Index impact on INSERT and UPDATE - Quiz 11easy Indexes and Query Performance - When indexes help and when they hurt - Quiz 7medium Indexes and Query Performance - Why indexes matter - Quiz 13medium Window Functions Fundamentals - Why window functions are needed - Quiz 6medium Window Functions Fundamentals - RANK and DENSE_RANK difference - Quiz 10hard