Computer Science
Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.
SQL Queries
15 Likes
Answer
SELECT ENAME, SAL
FROM empl
WHERE SAL >= 2200;
Output
+-----------+------+
| ENAME | SAL |
+-----------+------+
| MAHADEVAN | 2985 |
| BINA | 2850 |
| AMIR | 5000 |
| SHIAVNSH | 2450 |
| SCOTT | 3000 |
| FAKIR | 3000 |
+-----------+------+
Answered By
5 Likes
Related Questions
Assertion. DDL and DML both are part of SQL.
Reason. Both DDL and DML are interchangeable.
Assertion. Both BETWEEN and IN operators can choose from a list of values.
Reason. The value ranges and a list of values are interpreted in the same way in SQL.
Write a query to display details of employees who are not getting commission from table Empl.
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.