update t_test t1 set num = (
select num from (
select rowid id, row_number() over (partition by id order by id asc) num from t_test
) t2 where t1.rowid = t2. id
);
看到有人问如下问题: 花了些时间,弄出来了,记录如下: 核心代码: update t_test t1 set num = ( select num from ( select rowid id, row_number() over (partition by id order by id asc) num from t_...