17,382
社区成员




create table tmp_zxf_01(A varchar2(10),B varchar2(10));
insert into tmp_zxf_01 values('A',null);
insert into tmp_zxf_01 values('A',null);
insert into tmp_zxf_01 values(null,'A');
insert into tmp_zxf_01 values('B',null);
insert into tmp_zxf_01 values(null,'B');
insert into tmp_zxf_01 values(null,'B');
insert into tmp_zxf_01 values('A','B');
insert into tmp_zxf_01 values('A','B');
select a,b
from (
select a,b,row_number()over(partition by a,b order by a) rid
from tmp_zxf_01
) where rid>1
select user_id,qrbz,count(*) as cou
from askforleave
group by user_id,qrbz
having count(*)>1;
select user_id||qrbz ,count(*)
from askforleave
group by user_id||qrbz
having count(*)>1;
select a,b,count(*) as cou
from [table]
group by a,b
having count(*)>1