Another ‘Having’ example

SELECT Office, Max(Salary)

FROM Employee

WHERE Status = ‘full-time’

GROUP BY Office

HAVING Count(*) > 1

ORDER BY Office

Previous slide

Next slide

Back to first slide

View graphic version