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 ;
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )