delete Patient
from Patient as aa
left join (
select min(id) as id from Patient
group by patientid
) as bb
on aa.id = bb.id
where bb.id is null
SQL删除重复数据保留一条
delete Patient
from Patient as aa
left join (
select min(id) as id from Patient
group by patientid
) as bb
on aa.id = bb.id
where bb.id is null
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
