Question: Given a table with the following structure, which query returns all student names with the highest grade?

  1. `SELECT StudentName FROM Students WHERE Grade = MAX(Grade);`
  2. `SELECT TOP(1) StudentName FROM Students ORDER BY Grade;`
  3. `SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;`
  4. `SELECT StudentName, MAX(Grade) FROM Students ORDER BY Grade DESC;`

Answer: The correct answer of the above question is Option C:`SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;`