SELECT Query

Q:7
Display the AccNo and Name of depositors in the branch CALICUT.


SQL> SELECT ACCNO, NAME FROM DEPOSIT WHERE BRANCH='CALICUT';

     ACCNO NAME
---------- -------------------------
      1001 SYAM KUMAR
      1006 DEVA KUMAR
      1007 ASHOK KUMAR