← Quiz: Window Functions: all 10 questions
Quiz: Window Functions · Question 6 of 10
In the company table, what is the 4th highest DISTINCT salary (DENSERANK = 4)?
In the company table, what is the 4th highest DISTINCT salary (DENSE_RANK = 4)?
- A.72000
- B.45000
- C.58000
- D.40000
Answer & explanation
Correct answer: 58000
Distinct salaries in order: 95000, 88000, 72000, 58000 — the 4th is 58000.
Can you get the rest right without peeking?
Take the timed Quiz: Window Functions quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →