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