Using the HAVING Clause
Sheila needs to display the department ID and maximum salary for departments that have a maximum salary greater than $10,000. She will use use the HAVING clause to exclude any group results that do not meet the criterion of having a maximum salary of $10,000.
 |