I have a table that has 2 columns, one is column_ID and the other column_value. With this query :
(Select column_value FROM table1 group by column_value having COUNT(*)>1)) ,
I find the duplicated column_values and I want to delete the row where the Column_ID is with lower value for that row.
In this case I would like to delete the rows with column_ID equal to 1 and 3
How can I do that?