去重复 oracle

最新推荐文章于 2024-10-14 22:42:36 发布

bai30818

最新推荐文章于 2024-10-14 22:42:36 发布

阅读量51

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zshboke-2015/p/5353802.html

版权

select * from qy_base_control t where t.seq='5pbc5bnns5lpt';

select * from qy_base_control s where s.exchange_status='0';

select count(*) from qy_base_control s where s.exchange_status='0';--11
select count(*) from qy_base_control s where s.exchange_status='1';--15305

Select control_seq,Count(*) From qy_base_control Group By control_seq Having Count(*) > 1;--重复的流水号单字段

Select Name,sex,Count(*) From A Group By Name,sex Having Count(*) > 1--多字段

select * from qy_base_control t1 where t1.control_seq='511972510';--

--分析办件基础表 15316记录
select count(*) from qy_base_control s;--15316
select count(*) from (Select control_seq,Count(*) From qy_base_control Group By control_seq Having Count(*) > 1);--846条重复

select count(*) from (select control_seq,count(*) from qy_base_control group by control_seq);--共有14451条

------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from QY_BASE_CONTROL;
select count(*) from QY_BASE_CONTROL;--15316

转载于:https://www.cnblogs.com/zshboke-2015/p/5353802.html