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