1、查询单列重复
select * from lcgl_task_ti_b where prn in (select prn from lcgl_task_ti_b group by prn having count (prn) > 1)
2、查询多列重复的
select a.* from lcgl_task_ti_b a,(select order_prn,st from lcgl_task_ti_b group by order_prn,st having count(1)>1) as b where a.order_prn=b.order_prn and a.st=b.st