Skip to content

Instantly share code, notes, and snippets.

@gphil

gphil/having.sql

Created September 4, 2012 19:56
Show Gist options
  • Save gphil/3625695 to your computer and use it in GitHub Desktop.
Save gphil/3625695 to your computer and use it in GitHub Desktop.
Download ZIP
Having Clause
Raw
having.sql
SELECT city, state, ice_cream_parlor
FROM ice_cream_parlors icps
GROUP BY city, state
HAVING count(ice_cream_parlor) > 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment