查找数据库内表中重复数据

select u.boa_check_id
from T_BOA_CHECK_DATA_TEMP_check u
where u.pos_order_id in (select 
u1.pos_order_id
from T_BOA_CHECK_DATA_TEMP_check u1
group by u1.pos_order_id having count(*) > 1)
and u.boa_unit_id = 10016 and u.boa_job_id in(
select 
u1.boa_job_id
from T_BOA_CHECK_DATA_TEMP_check u1
group by u1.boa_job_id having count(*) > 1)