Abhishek
>I want the output as:
>LHR 3
>AKL 2
>AWL 1...
>ie the no of entires sorted by their no of appearences.
SELECT
tbl.name AS Name,
COUNT( tbl.name) AS Count
FROM tbl
GROUP BY tbl.name
ORDER BY Count DESC;
PB
[EMAIL PROTECTED] wrote:
Hi Friends,
I have a table like
name
MAD
LHR
MAD
LHR
AKL
AWL
AKL
LHR
I want the output as:
LHR 3
AKL 2
AWL 1
etc...
ie the no of entires sorted by their no of appearences.
I cannot do that by select name from tab_name group by name as it will not
give me the no of rows.
Pl. help me to find it. I know it would be simple but i think i am missing
some basic of MySQL.
Thanks
--
Regards
Abhishek Jain
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.5/177 - Release Date: 11/21/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
