一个表中有若干相同的记录,用SQL语句怎么删除重复记录,只保留唯一一条呢?
------解决方案--------------------
方法一
先备份表，删除了重新插于
create table test as (select distinct * from test1)
truncate table test
insert into test select * from test1;
drop table test1
方法二
delete from test where rowid not in (select max(t1.rowid) from test1 t1 group by id,city,num)
------解决方案--------------------
delete from tab a where a.rowid not in (select max(rowid) from tab b where a.id=b.id)