现有一个表student:
select * from student;
然后加上一列序号:
select row_number() over(partition by 1) as xuhao,
a.*
from student a;
得到结果:
现有一个表student:
select * from student;
然后加上一列序号:
select row_number() over(partition by 1) as xuhao,
a.*
from student a;
得到结果: