Exercise: Max Score Student
Find student with highest marks.
Solution
sql
1SELECT * FROM students
2WHERE marks = (SELECT MAX(marks) FROM students);
Find student with highest marks.
1SELECT * FROM students
2WHERE marks = (SELECT MAX(marks) FROM students);