摘要： --查询重复的记录并显示select * from [DVP_OF].[dbo].[OF_Ofddntval_dvp]where (Fundcd+Clsdt+CAST(Naps as nvarchar(100))+CAST(Accnav1 as nvarchar(100))) in (SELECT (Fundcd+Clsdt+CAST(Naps as nvarchar(100))+CAST(Accnav1 as nvarchar(100))) FROM OF_Ofddntval_dvp GROUP BY Fundcd,Clsdt,Naps,Accnav1 HAVING COUNT (... 阅读全文