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  name from BaseDoctor group by  hiscode,name having count(*) > 1

ps验证看一下
3查询这些重复的人code最小的是那些

select min(code) from BaseDoctor group by  hiscode,name having count(*)>1

总的就是先查询哪些人需要删除，再查应该留下的最小代码
然后过滤，查询，然后改成 delete