6               c                 pp
5               b                 pp

复制代码 代码如下:

select   max([id])   from   YourTable  
where peopleId in (select   peopleId from people group by   peopleId   having count(peopleId) > 1)
id           name         value

查询及删除重复记录的SQL语句
1               a                 pp

4               b                 pp

复制代码 代码如下:

select * from people
)b   on   a.id=b.id

3               b                 iii

复制代码 代码如下:

select   id=min(id)   from   表   group   by   name,value
select * from vitae a
查询及删除重复记录的SQL语句

delete   YourTable  
delete   a
group   by   (name   +   value))

8               c                 iii

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
id           name         value
delete from people

复制代码 代码如下:

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

3、查找表中多余的重复记录（多个字段）
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)
5、查找表中多余的重复记录（多个字段），不包含rowid最小的记录
2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录
where (a.peopleId,a.seq) in   (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
要求得到这样的结果

8               c                 iii

例如：
7               c                 pp

复制代码 代码如下:

delete from vitae a
方法2

复制代码 代码如下:

4、删除表中多余的重复记录（多个字段），只留有rowid最小的记录

6               c                 pp

and rowid not in (select min(rowid) from   people group by peopleId having count(peopleId )>1)
3               b                 iii
where   b.id   is   null
2               a                 pp

from   表   a   left   join(
4               b                 pp
1               a                 pp
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)

方法1

复制代码 代码如下:

where   [id]   not   in   (

id是主键