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-3 Table creation Show table structure Record Insertion Simple Query SELECT with COUNT() SELECT with MIN() and MAX() Simple Query SELECT with MAX() SELECT with ORDER BY .. DESC SELECT with BETWEEN SELECT with COUNT() Show all records UPDATE Query SELECT USING COUNT() with GROUP BY COUNT() with GROUP BY and ORDER BY


SELECT with ORDER BY .. DESC

Q:9
Display the names of students in the descending order of total mark.


SQL> SELECT ROLLNO, NAME, TOTAL FROM STUDENT ORDER BY TOTAL DESC;

    ROLLNO NAME                           TOTAL
---------- ------------------------- ----------
       203 GEORGE                           500
       206 SOMAN                            420
       204 JIBIN                            400
       201 JOHN                             300
       205 VARGHESE                         250
       202 BABU                             200

6 rows selected.