Computer Science
Write a query to display employee name and salary of those employee who don't have their salary in the range of 2500 to 4000.
Answer
SELECT ENAME, SAL
FROM empl
WHERE SAL NOT BETWEEN 2500 AND 4000;
Output
+----------+------+
| ENAME | SAL |
+----------+------+
| SMITH | 800 |
| ANYA | 1600 |
| SETH | 1250 |
| MOMIN | 1250 |
| AMIR | 5000 |
| KULDEEP | 1500 |
| SHIAVNSH | 2450 |
| ANOOP | 1100 |
| JATIN | 950 |
| MITA | 1300 |
+----------+------+
Related Questions
Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.
Write a query to display details of employees who are not getting commission from table Empl.
Write a query to display the name, job title and salary of employee who do not have manager.
Write a query to display the name of employee whose name contains 'A' as third alphabet.