1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
代码如下:
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1) 2、删除表中
首先用户要对数据库有完全的权限，创建，删除表create table bak as (select * from cdb_threads group by subject having count(*)=1);创建一个数据库，把未重复的提取出来insert into bak (select * from cdb_threads group by subject having count(*)>
========第一篇=========
在一张表中某个字段下面有重复记录，有很多方法，但是有一个方法，是比较高效的，如下语句：
select data_guid from adam_entity_datas a where a.rowid > (select min(b.rowid) from adam_entity_datas b where b.data_guid = a.data
在web_hk_roadway数据表中根据ROADWAY_CODE查询ROADWAY_NAME得时候发现一个code查询出来了多条name，因此决定首先对数据表中ROADWAY_CODE和ROADWAY_NAME一致的数据进行去重处理，下面是去重成功的语句DELETEFROM web_hk_roadwayWHERE ID NOT IN ( SELECT t.max_id FROM ( SELECT max( ID ) AS max_id FROM web_hk_roadway G...
基本常用查询
--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
