Quick Search:
 
 mySQL: Grouping rows by frequency Jump to:  
Category: >> mySQL >> Grouping rows by frequency  

<< lastnext >>

Snippet Name: Grouping rows by frequency

Description: Handy little query that groups rows by frequency.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT DISTINCT field_name, COUNT(*) AS num 
FROM table_name 
GROUP BY field_name 
ORDER BY num DESC


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org