select PLN_WSP_ID from Web_Pas_Plans_Management_Vw n where PLN_CST_CSTMCD='WCWL' and n.PLN_WSP_ID in (
select m.PLN_WSP_ID from Web_Pas_Plans_Management_Vw m where PLN_CST_CSTMCD='WCWL'
group by m.PLN_WSP_ID
having count(m.PLN_WSP_ID) > 1
)
oracle查询列的重复数据
最新推荐文章于 2023-04-29 03:30:00 发布