Skip to content

Instantly share code, notes, and snippets.

@roelven

roelven/gist:663332

Created November 4, 2010 22:44
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save roelven/663332 to your computer and use it in GitHub Desktop.
Download ZIP
Sort amount of results per city in mysql
Raw
gistfile1.sql
SELECT `plaats`, count(*) AS `Number`
FROM `kijkmijnhuis`
GROUP BY `plaats`
ORDER BY `Number` DESC
LIMIT 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment