[thelist] mysql count question

[Anthony Baratta]

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."