1、单个字段
查询所有重复数据
select * from ActivityWinUser where (UID) in(select UID from ActivityWinUser group by UID having count(*)>1);
去重
delete from table where Name in(select Name from table group by Name having count(*)>1);
2、多个字段
查询所有重复数据
select * from table a where (a.UID,a.ActivityID) in (select UID,ActivityID from table group by UID,ActivityID having count(*) > 1) ;
3、去除重复记录
select *, count(distinct name) from table group by name
---------------------
作者:想你时的孤独
来源:CSDN
原文:https://blog.csdn.net/u013091013/article/details/51333155
版权声明:本文为博主原创文章,转载请附上博文链接!
注:select ex_id from zqc_log_exzdcs where d_created_date>'2018-12-20 17:12:00' and d_created_date<'2018-12-20 17:15:00' group by ex_id having count(*)>1;