Remove rows with multiple duplicate columns
Posted by navaneeth on Nov 14, 2013 in General, MySQL, Php | No comments yet
Some times we need to remove rows with multiple duplicate columns as shown in the table below,See the last two rows with same values.
ID college courses
183 24 102
151 24 52
155 24 66
179 24 66
With the help of temporary table we can remove rows and here is the query to remove the rows
CREATE TABLE temp_table AS (SELECT * FROM table); DELETE FROM table WHERE ID NOT IN (SELECT ID FROM (SELECT * FROM temp_table ORDER BY ID DESC) as temp_table GROUP BY college, courses); DROP TABLE temp_table ;
Hope it helps to remove rows with multiple duplicate columns
Leave a Reply