Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
SQL Lab Exercises-2 Table creation Show Structure Record Insertion Update Query SELECT with MAX() SELECT with ORDER BY SELECT with MAX() Nested Query SELECT Query SELECT with AVG()


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