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 ORDER BY

Q:6
Display the names in ascending order.


SQL> SELECT NAME FROM STUDENT ORDER BY NAME;

NAME
-------------------------
AJAS
AJMAL
BABU RAJ
JOHNSON
ROGER
SABU

6 rows selected.