removing duplicate entries

[keak]

Hi there,
I have a database where there are are records that have the same first_name and last_name (some of the names have 3 4 duplicates).

Is there a good way to delete the duplicates through pgadmin3 or a SQL statement for this situation?

Any input will be great!

 

[gwinn7]

Try something like this...


delete FROM public.testtable
where id not in
(select min(id) from public.testtable
group by firstname, lastname);


Gary
gwinn7