例如：
id           name         value
1               a                 pp
2               a                 pp
3               b                 iii
4               b                 pp
5               b                 pp
6               c                 pp
7               c                 pp
8               c                 iii
id是主鍵
要求得到這樣的結(jié)果
id           name         value
1               a                 pp
3               b                 iii
4               b                 pp
6               c                 pp
8               c                 iii

方法1

復(fù)制代碼 代碼如下:

delete   YourTable  
where   [id]   not   in   (
select   max([id])   from   YourTable  
group   by   (name   +   value))

復(fù)制代碼 代碼如下:

delete   a
from   表   a   left   join(
select   id=min(id)   from   表   group   by   name,value
)b   on   a.id=b.id
where   b.id   is   null

查詢及刪除重復(fù)記錄的SQL語(yǔ)句
查詢及刪除重復(fù)記錄的SQL語(yǔ)句
1、查找表中多余的重復(fù)記錄，重復(fù)記錄是根據(jù)單個(gè)字段（peopleId）來(lái)判斷

復(fù)制代碼 代碼如下:

select * from people
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)

復(fù)制代碼 代碼如下:

delete from people
where peopleId in (select   peopleId from people group by   peopleId   having count(peopleId) > 1)
and rowid not in (select min(rowid) from   people group by peopleId having count(peopleId )>1)

復(fù)制代碼 代碼如下:

select * from vitae a
where (a.peopleId,a.seq) in   (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)

復(fù)制代碼 代碼如下:

delete from vitae a
where (a.peopleId,a.seq) in   (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)

復(fù)制代碼 代碼如下: