I tried this but I miss the cName... thanks a lot J.R
On 4/11/06, J.R. Bullington [EMAIL PROTECTED] wrote:
Select COUNT(names) 'cName' FROM tblname GROUP BY names ORDER BY cName
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
J.R.
-Original Message-
From: jakot05 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 12:37 PM
To: mysql@lists.mysql.com
Subject: Results Rank
Hi!
I have a table like this
names
···
john
peter
mary
peter
john
peter
mike
mary
mary
mary
···
I want to get a list ordered by the number of times the name appears in
the
table, in the example:
mary
peter
john
mike
How I can do this?...thanks a lot for the answers
*** note: I don´t know wich are the names in the table, are changing all
the
time ***
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]