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 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