Ridgejp
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
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
Why would you have duplicate content, could you elaborate...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Julian. Exactly what I needed.
J
J
You are welcom