文章分类 -  SQL

sqlserver查询和册除重复数据-亲测可用
摘要：查询重复数据 SELECT * from KS_U_shangbaoguanli_copy where sfznum in (SELECT sfznum FROm KS_U_shangbaoguanli_copy GROUP BY sfznum having count(sfznum)>1) 删除重 阅读全文
posted @ 2022-08-30 17:39 IT_农民 阅读(116) 评论(0) 推荐(0)