[thelist] mysql count question
Anthony Baratta
Anthony at Baratta.com
Fri Mar 21 17:43:08 CST 2003
At 02:36 PM 3/21/2003, Dunstan Orchard wrote:
>I want to select these names, count them, order them large-count>small-count,
>then display one instance of each name with its count value next to it.
select Name, Count(Name) from tblNames
group by Name
order by Count(Name) DESC
Hope that helps.
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list