查出不唯一的保单号SQL

查出不唯一的保单号

 

select *
  from fe_commision u
 where u.plyno in
       (select u.plyno from fe_commision u group by u.plyno having count(*) > 1)