SELECT myField, COUNT(*) AS 'inelegantCount'
FROM myTable
GROUP BY myFieldIt's the classic GROUP BY statement example - which I can't manage to remember, thus the blog post.
Monday, April 20, 2009
[SQL] Counting Rows with the Same Value of a Given Field
Here's a piss-easy script to count the number of rows in a table where a given field has the same value:
It's the classic GROUP BY statement example - which I can't manage to remember, thus the blog post.
It's the classic GROUP BY statement example - which I can't manage to remember, thus the blog post.
Subscribe to:
Post Comments (Atom)
3 comments:
Hi. I always forget this, too (hence my visit...).
Also useful to add is
order by count(*) desc/asc
so you can see which value has most/least entries
Thanks, I always forget this, too.
thanks!
Post a Comment