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.