🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Nothing special
  2. B.Ties: two employees can share the top salary, so both may be returned
  3. C.That NULL salaries are highest
  4. 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 →