SQL - Window Functions Fundamentals
Which of the following is the correct syntax to assign row numbers partitioned by
department and ordered by salary?Which of the following is the correct syntax to assign row numbers partitioned by department and ordered by salary?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall correct syntax for ROW_NUMBER()
The correct syntax usesOVER (PARTITION BY ... ORDER BY ...)to partition and order rows.Step 2: Check each option
ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary) correctly places PARTITION BY before ORDER BY inside OVER(). Other options have incorrect order or missing OVER keyword.Final Answer:
ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary) -> Option DQuick Check:
Correct syntax = ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...) [OK]
Quick Trick: Use OVER (PARTITION BY ... ORDER BY ...) with ROW_NUMBER() [OK]
Common Mistakes:
- Omitting OVER keyword
- Swapping ORDER BY and PARTITION BY order
- Using PARTITION BY outside OVER()
Master "Window Functions Fundamentals" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes