数据库(记录)
一个表中有若干相同的记录,用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)
