SELECT with BETWEEN

Q:11
Display the details of Customers from AccNo 1001 to 1005.


SQL>  SELECT * FROM DEPOSIT WHERE ACCNO BETWEEN 1001 AND 1005;

     ACCNO NAME                          AMOUNT BRANCH
---------- ------------------------- ---------- --------------------
      1001 SYAM KUMAR                     55000 CALICUT
      1002 RAM KUMAR                      25000 COCHIN
      1003 KRISHNA KUMAR                  45000 TRICHUR
      1004 MOHAN KUMAR                     5000 COCHIN
      1005 ANIL KUMAR                     35000 TRICHUR