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-4 Table Creation Show structure Insertion of Records SELECT Query SELECT Query SELECT with ORDER BY SELECT Query SELECT Query SELECT Query SELECT Query SELECT with BETWEEN Nested Query SELECT with COUNT() SELECT with SUM() UPDATE Query SELECT with SUM, GROUP BY and ORDER BY


SELECT with ORDER BY

Q:6
Display the accounts branch wise in ascending order of AccNo.


SQL>  SELECT BRANCH, ACCNO,NAME FROM DEPOSIT ORDER BY BRANCH, ACCNO;

BRANCH                    ACCNO NAME
-------------------- ---------- -------------------------
CALICUT                    1001 SYAM KUMAR
CALICUT                    1006 DEVA KUMAR
CALICUT                    1007 ASHOK KUMAR
COCHIN                     1002 RAM KUMAR
COCHIN                     1004 MOHAN KUMAR
TRICHUR                    1003 KRISHNA KUMAR
TRICHUR                    1005 ANIL KUMAR

7 rows selected.