Which of the following is the correct syntax to assign a rank using DENSE_RANK() ordered by salary descending?

easy📝 Syntax Q3 of 15

SQL - Window Functions Fundamentals

Which of the following is the correct syntax to assign a rank using DENSE_RANK() ordered by salary descending?

ASELECT employee, RANK() DENSE_RANK ORDER BY salary DESC FROM employees;

BSELECT employee, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees;

CSELECT employee, DENSE_RANK BY salary DESC FROM employees;

DSELECT employee, DENSE_RANK(salary DESC) FROM employees;

Step-by-Step Solution

Solution:

Step 1: Recall correct window function syntax
DENSE_RANK() requires OVER clause with ORDER BY inside parentheses.
Step 2: Check each option for syntax correctness
SELECT employee, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees; uses correct syntax: DENSE_RANK() OVER (ORDER BY salary DESC).
Final Answer:
SELECT employee, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees; -> Option B
Quick Check:
Correct DENSE_RANK syntax = D [OK]

Quick Trick: Window functions need OVER() with ORDER BY inside [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes