Re: double mistakes

[Geert Vanderkelen]

Hi ,

You can find doubles this way:

select name, count(*) as cnt from customer group by name having count > 1;

This will give you all names that have two or more entries.

You then can do:

select * from customer where name = '<name>';
to find the records and eventually change them.


Regards,

Geert