Link to home
Start Free TrialLog in
Avatar of Ridgejp
RidgejpFlag for United Kingdom of Great Britain and Northern Ireland

asked on

MySql Deletion of Row Data Where Count > 1

Hi,

Just to want an easy way to thin out duplication in a table. I have column1, column2 and column3 - where the count of column1 is greater than 1 then I need a select statement to perform a delete query that limits the deletion to 1.

Any thoughts?

J
Avatar of lenamtl
lenamtl
Flag of Canada image

Why would you have duplicate content, could you elaborate...
ASKER CERTIFIED SOLUTION
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ridgejp

ASKER

Thanks Julian. Exactly what I needed.

J
You are welcom