Bird
0
0

Identify the error in this query:

medium📝 Debug Q6 of 15
SQL - Window Functions Fundamentals

Identify the error in this query:
SELECT id, NTILE(4) ORDER BY salary FROM employees;

ANTILE cannot be used with numeric columns
BORDER BY cannot be used inside NTILE
CMissing OVER() clause after NTILE(4)
DMissing GROUP BY clause
Step-by-Step Solution
Solution:

  1. Step 1: Check NTILE syntax

    NTILE requires an OVER() clause with ORDER BY inside it.

  2. Step 2: Analyze the query

    The query uses ORDER BY outside OVER(), which is invalid syntax.

  3. Final Answer:

    Missing OVER() clause after NTILE(4) -> Option C

  4. Quick Check:

    NTILE needs OVER() with ORDER BY [OK]
Quick Trick: Always use OVER() with NTILE [OK]
Common Mistakes:
  • Placing ORDER BY outside OVER()
  • Assuming NTILE works without OVER()
  • Confusing NTILE with GROUP BY

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
CASE Expressions - Simple CASE syntax - Quiz 6medium Common Table Expressions (CTEs) - CTE as readable subquery replacement - Quiz 7medium Common Table Expressions (CTEs) - Recursive CTE for series generation - Quiz 4medium Indexes and Query Performance - Covering index concept - Quiz 3easy Indexes and Query Performance - CREATE INDEX syntax - Quiz 13medium SQL Security Basics - How SQL injection exploits queries - Quiz 15hard SQL Security Basics - Parameter binding mental model - Quiz 5medium Stored Procedures and Functions - User-defined functions - Quiz 11easy Stored Procedures and Functions - Parameters (IN, OUT, INOUT) - Quiz 9hard Transactions and Data Integrity - Deadlock concept and prevention - Quiz 12easy