Nested Query

Q:8
Display the name of the student with highest total.


SQL> SELECT NAME FROM STUDENT WHERE TOTAL = (SELECT MAX(TOTAL) FROM STUDENT);

NAME
-------------------------
BABU RAJ