1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
代码如下:
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1) 2、删除表中
基本常用查询
--select
select * from student;
--all 查询所有
select all sex from student;
--distinct 过滤重复
select distinct sex from student;
--count 统计
select count(*) from student;
select count(sex) from s
