MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Find double (not uniqe) entries in a table
Posted by: Aziz
Date: August 17, 2005 06:01AM

Hi,

I'm not totally sure, but maybe this is the right query:

SELECT id, name, city, count(*) AS cnt
FROM a_table
GROUP BY name
HAVING cnt > 1;

Regards,
Aziz

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Find double (not uniqe) entries in a table
security.member
August 17, 2005 03:21AM
Re: Find double (not uniqe) entries in a table
Aziz
August 17, 2005 06:01AM
Re: Find double (not uniqe) entries in a table
Aziz
August 17, 2005 06:21AM
Re: Find double (not uniqe) entries in a table
Roland Bouman
August 18, 2005 04:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.