Show Me Glossary
 

Restricting Groups

Previous previous|next Next Page

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.

Launch Demonstration

Show Me and Try It! - Use SQL Workshop to build this report