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

SELECT with MIN() and MAX()

Q:6
Display the highest and lowest mark in COMMERCE batch.


SQL> SELECT MIN(TOTAL), MAX(TOTAL) FROM STUDENT WHERE BRANCH='COMMERCE';

MIN(TOTAL) MAX(TOTAL)
---------- ----------
       300        400