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)