MYSQL - Removing Duplicated Rows
Posted: Thu Oct 04, 2007 1:50 am
How do I delete DUPLICATE ROWS from my MYSQL Database?
I have a large number of rows that have been duplicated. Obviously I only need 1 of each.
Example:
[RPO_CODES] [DESCRIPTION]
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
I want to do this simply with SQL Query. I was told DISTINT would work? Help. How.. Thanks.
I have a large number of rows that have been duplicated. Obviously I only need 1 of each.
Example:
[RPO_CODES] [DESCRIPTION]
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
I want to do this simply with SQL Query. I was told DISTINT would work? Help. How.. Thanks.