有问题也只是业务逻辑问题,别人是看不出来的 可以 with t as (select a.XMDZ,a.XMMC,b.DH,b.YC_JZMJ,c.FZRQ,d.YHZH,e.HSMJ,e.YT,e.YSZH,a.rowid rid from kfs_xmb a left join kfs_db b on a.XMBH=b.XMBH left join kfs_dfzxxb c on c.XMBH=b.XMBH left join kfs_djgyh d on c.YWZH=d.YWZH left join kfs_hsxsfw e on e.YC_CLH=b.YC_CLH ) select * from t where rid in(select rid from t group by rid having count(1)>1)找出重复的记录
可以
with t as (select a.XMDZ,a.XMMC,b.DH,b.YC_JZMJ,c.FZRQ,d.YHZH,e.HSMJ,e.YT,e.YSZH,a.rowid rid from kfs_xmb a left join kfs_db b on a.XMBH=b.XMBH
left join kfs_dfzxxb c on c.XMBH=b.XMBH left join kfs_djgyh d on c.YWZH=d.YWZH left join kfs_hsxsfw e on e.YC_CLH=b.YC_CLH
)
select * from t
where rid in(select rid from t group by rid having count(1)>1)找出重复的记录