查询一个表中，多个字段作为唯一重复的数据 原创

查询一个表中，多个字段作为唯一重复的数据

复制收展SQLselect *
from um_form ab
where (ab.FM_CLS, ab.FMNO, ab.INPUTOR, ab.CASEID) in (
    select b.FM_CLS,
           b.FMNO,
           b.INPUTOR,
           b.CASEID
    from um_form b
    group by b.FM_CLS, b.FMNO, b.INPUTOR, b.CASEID
    having count(1) > 1
);
1
2
3
4
5
6
7
8
9
10
11