1.

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

Answer»

SELECT job FROM emp GROUP BY job HAVING MAX(salary)>=3000;



Discussion

No Comment Found

Related InterviewSolutions