DELETE id FROM 表1 WHERE id not in (select min(id) from 表1 group by title)
删除title 重复的
- SQL语句where id in 排序按in的顺序显示 (2013-1-8 14:32:44)
- 去除数据库中重复的数据(sql语句) (2011-4-4 23:27:17)
DELETE id FROM 表1 WHERE id not in (select min(id) from 表1 group by title)
删除title 重复的
最新评论