[Solved] Find the mistake in this query:SELECT name, NTILE(5) OVER (PARTITION salary ORDER BY name) AS group_num FROM staff; | SQL

SQL - Window Functions Fundamentals

Find the mistake in this query:
SELECT name, NTILE(5) OVER (PARTITION salary ORDER BY name) AS group_num FROM staff;

APARTITION BY keyword is missing

BNTILE cannot be used with PARTITION BY

CORDER BY should come before PARTITION BY

DNTILE requires a GROUP BY clause

Step-by-Step Solution

Solution:

Step 1: Review PARTITION BY syntax
PARTITION BY must be followed by a column name; keyword BY is required.
Step 2: Identify error in query
The query uses PARTITION salary instead of PARTITION BY salary, causing syntax error.
Final Answer:
PARTITION BY keyword is missing -> Option A
Quick Check:
PARTITION BY requires 'BY' keyword [OK]

Quick Trick: Use PARTITION BY, not PARTITION alone [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this query: