Re: Query for duplicate records

On 18/10/10 06:55, Ron Piggott wrote:

Is there a query you could help me write a SELECT query that would search table ministry_profiles for where column organization has the same organization more than once? I am trying to delete the duplicate organization records, but I am working with 1,000+ businesses and I can't go through each record looking for duplicates.

select organization, count(*) from ministry_profiles group by organization having count(*) > 1; gives you which organization has more than 1 account (and how many duplicates you are dealing with). -- Postgresql & php tutorials http://www.designmagick.com/