删除总账表中的冗余数据 delete [GL_accsum] from [GL_accsum] as v where not exists(SELECT * FROM [GL_accsum] as a where [iperiod] between 1 and 12 group by [ccode],[iperiod] having min([i_id])= [v].[i_id]) 删除辅助总账表中的冗余数据 delete [GL_accass] from [GL_accass] v where not exists(SELECT * FROM [GL_accass] where [iperiod] between 1 and 12 group by [ccode], [cdept_id], [cperson_id], [ccus_id], [csup_id], [citem_class], [citem_id],[iperiod] having min([i_id])=v.[i_id])