oracle

1.select t.idkey from XAWS_SEALMACHINE_SEAL_INFO t
where org_code = '000'
and operate_status = '304') group by h.physical_seal_id
having count(physical_seal_id) < 2

2.select count(physical_seal_id),h.physical_seal_id from xaws_physical_handle_record h
where h.physical_seal_id in (
select t.idkey from XAWS_SEALMACHINE_SEAL_INFO t
where org_code = '000'
and operate_status = '304') group by h.physical_seal_id
having count(physical_seal_id) < 2)

3.select physical_seal_id from (

select count(physical_seal_id),h.physical_seal_id from xaws_physical_handle_record h
where h.physical_seal_id in (
select t.idkey from XAWS_SEALMACHINE_SEAL_INFO t
where org_code = '000'
and operate_status = '304') group by h.physical_seal_id

having count(physical_seal_id) < 2))