Re: Problem with "Find Duplicates" using subquery

[sai ram]

Hi.,

I have a very simple solution.,

Just group by the column for which you don't want duplicates and do a select * from .,

you will be surprised to see the result coming without duplicates.,

It should be like this ,.

select * from Donations group by date,amt,donor

No inner joins, no sub query etc.,

The point is .,when " select * from " is used .,along with group by ., mysql engine .,takes the first row of matching record.,



Hope it makes sense..,

Sairam
GofrugalTech
Chennai,India