SELECT Query

Q:8
Display the AccNo of depositors who have deposited more than Rs. 10,000/- and less than Rs. 50,000/-.


SQL> SELECT ACCNO, NAME FROM DEPOSIT WHERE AMOUNT BETWEEN 10000 AND 50000;

     ACCNO NAME
---------- -------------------------
      1002 RAM KUMAR
      1003 KRISHNA KUMAR
      1005 ANIL KUMAR
      1007 ASHOK KUMAR