← Quiz: SQL Interview Queries: all 10 questions
Quiz: SQL Interview Queries · Question 5 of 10
"Highest salary in each department with the employee name" — what must you mention?
"Highest salary in each department with the employee name" — what must you mention?
- A.Nothing special
- B.Ties: two employees can share the top salary, so both may be returned
- C.That NULL salaries are highest
- D.That GROUP BY can return names directly
Answer & explanation
Correct answer: Ties: two employees can share the top salary, so both may be returned
With equal top salaries, a correct query returns all of them (or you must state a tie-break rule).
Can you get the rest right without peeking?
Take the timed Quiz: SQL Interview Queries quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →