第一句语法有问题
with ss as(select row_number() over (partition by a.name order by a.name) as rn,a.* from table a)
第二句应该是不行,不能更新基本表中的数据
with ss as(select row_number() over (partition by a.name order by a.name) as rn,a.* from table a)
第二句应该是不行,不能更新基本表中的数据
update a a1
set number=(select a1.number+count(1)
from a
where name=a1.name and rowid<a1.rowid)