Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

MySQL select query for grouping rows by frequency (See related posts)

SELECT DISTINCT field_name, COUNT(*) AS num FROM table_name GROUP BY field_name ORDER BY num DESC
to mysql by sikelianos on Mon Jan 21 13:16:57 -0500 2008

You need to create an account or log in to post comments to this site.


Click here to browse all 5143 code snippets

Related Posts