...blind as a bat, it was right in front of me in basic SQL .
Thank you kindly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just drop the 'distinct' - should give you what you want
mysql> select count(last_name) as "LnameCnt", last_name from table_ABC group by last_name;
hth
steve
[EMAIL PROTECTED] wrote:
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table with the same last name, b
