Skip to content

Instantly share code, notes, and snippets.

@gphil

gphil/having.sql

Created September 4, 2012 19:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gphil/3625695 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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