Oracle根据多个字段进行查重

根据两个字段去重 （a，b）

select *  from tab t where (t.a, t.b) in (select t1.a, t1.b                        from tab t1                       group by (t1.a, t1.b)                      having count(*) > 1)