Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 8 of 78

Simple Queries in SQL — Question 1

Back to all questions
1
Question

Question 1

Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.

Answer 
SELECT ENAME, SAL  
FROM empl   
WHERE SAL >= 2200;
Output
+-----------+------+
| ENAME     | SAL  |
+-----------+------+
| MAHADEVAN | 2985 |
| BINA      | 2850 |
| AMIR      | 5000 |
| SHIAVNSH  | 2450 |
| SCOTT     | 3000 |
| FAKIR     | 3000 |
+-----------+------+