mysql删除重复数据只保留一条

sql 语句 select 后结果 删除重复，只保留一条 DELETE FROM table WHERE id INSELECT id FROMSELECT ROW_NUMBER()OVER(PARTITION BY item_id ORD...