Thanks for your help, just what I needed. I will play around but if you have a chance and know how, how would I order the results by count? (ie. highest counts first..)
-----Original Message----- From: Mike Knox [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 5:09 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks! Paul How about select FIRST_NAME, count(*) from a table group by FIRSTNAME having count(FIRST_NAME) > 1 Mike ---------------------------------------------------------------------------- -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ============================================================================ == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]