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.
SQL Queries
4 Likes
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 |
+----------+------+
Answered By
1 Like
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.