Restricting Groups |
||||||||
Sheila needs to display the department ID and maximum salary for departments that have a maximum salary greater than 10000. She will use use the HAVING clause to exlude any group results that do not meet the criterion of having a maximum salary of 10000.
|