Question: Given a table with the following structure, which query returns all student names with the highest grade?
- `SELECT StudentName FROM Students WHERE Grade = MAX(Grade);`
- `SELECT TOP(1) StudentName FROM Students ORDER BY Grade;`
- `SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;`
- `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;`