Q. Display only the jobs with maximum salary greater than or equal to 3000.
You can understand by seeing this video ---
SELECT JOB FROM DEPARTMENTS GROUP BY JOB HAVING MAX(SALARY) >= 3000 ;
You can understand by seeing this video ---
SELECT JOB FROM DEPARTMENTS GROUP BY JOB HAVING MAX(SALARY) >= 3000 ;
Can we use aggregate functions directly in having / wher clause or should it be nested like :
ReplyDeleteSelect job form department group by job having salary = ( select max( salary ) from department);
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )