(资料图片)
1、delete from Tbwhere id not in (select b.id from(SELECT DISTINCT first_value(id) over(partition by name) as id,name FROM Tb) b)。
本文就为大家分享到这里,希望小伙伴们会喜欢。