jiumoji 发表于 2013-1-14 08:50:04

删除表中重复数据，只留一条不重复数据

delete from test where rowid not in (select max(rowid) from test group by id)
页: [1]
查看完整版本: 删除表中重复数据，只留一条不重复数据