delete from(select row_number() over(partition by 字段名 order by 字段名) as row_no from 表名 ) where row_no>1
我的个人博客地址:http://www.dbhx.vip
delete from(select row_number() over(partition by 字段名 order by 字段名) as row_no from 表名 ) where row_no>1
我的个人博客地址:http://www.dbhx.vip