CBSE Class 12 Informatics Practices Question 74 of 90

Querying Using SQL — Question 14

Back to all questions
14
Question

Question 14

Display only the jobs with maximum salary greater than or equal to 3000.

Answer
SELECT Job 
FROM Empl 
GROUP BY Job HAVING MAX(Sal) >= 3000;
Output
+-----------+
| Job       |
+-----------+
| PRESIDENT |
| ANALYST   |
+-----------+