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.