Syntax for HAVING
SELECT type, count(*) FROM titles GROUP BY type HAVING count(*) > 1
Results: _type__ ____ business 4 mod_cook 2
Previous slide
Next slide
Back to first slide
View graphic version