![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
小六6啊
小白上手
展开
-
windows2019无系统资源盘安装.net3.5
[https://download.csdn.net/download/baidu_38302048/85336629]1下载数据库内资源包解压!一直解压到sxs!!!2选择安net.3.5下一步3选择指定备用源路径,选择路径注意到sxs下,然后下一步。等待结束就OK了。原创 2022-05-10 14:48:37 · 529 阅读 · 0 评论 -
sqlserver去重保留code最小的值
整体select* from BaseDoctor where name in (select name from BaseDoctor group by hiscode,name having count(*) > 1) and code not in (select min(code) from BaseDoctor group by hiscode,name having count(*)>1) 思路1查到有重复的数据2查询有重复的数据有那些人select原创 2021-11-08 17:28:01 · 324 阅读 · 0 评论