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()


SELECT with MAX()

Q:5
Display highest marks in sub2.


SQL> SELECT MAX(SUB2) FROM STUDENT;

 MAX(SUB2)
----------
        95