Removing duplicates...

[RIRedinPA]

I know this is a common question but I need some help, my query isn't working.

 

I have a db with the fields id (primary key, auto-increment), name, email, storeStatus, storePhoto, storeAds

 

There are several duplicates where the id is unique but the name, email, etc, are duplicated.

 

I've tried:

 

CREATE TABLE emailListDuplicate SELECT * FROM emailList GROUP BY id, name, email, storeStatus, storePhoto, storeAds

 

but that is just giving me a complete duplicate of the original table. How can I create a new table with just distinct records from the first one?

 

Thanks

[RIRedinPA]

OK, I need to update the problem, only the name and email fields are being duplicated, the remaining three fields are not, so what I need to do is weed out the duplicates by keeping the record that has the lowest id #

[kkubek]

 

How about:

 

CREATE TABLE emailListDuplicate SELECT (minIid),name, email, storeStatus, storePhoto, storeAds

FROM emailList

GROUP BY id, name, email, storeStatus, storePhoto, storeAds