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-1 Table Creation Show Structure Record Insertion Update - 1 Update - 2 Select Query - 1 Select Query - 2 Select Query - 3 Select Query - 4 Select Query - 5 Select Query - 6 SELECT with SUM() SELECT with AVG() SELECT with DISTINCT SELECT with BETWEEN SELECT with GROUP BY


SELECT with BETWEEN

Q:15
Display the details of employees with salary between Rs. 10,000/- and Rs. 50,000/-


SQL> SELECT EMPNO,NAME,TOTAL FROM EMPLOYEE WHERE TOTAL BETWEEN 10000 AND 50000;

     EMPNO NAME                           TOTAL
---------- ------------------------- ----------
         2 THOMAS KUTTY                   14000
         3 WILLAIMS                       35000
         4 JIJI JOHNSON                   42000