现有一个表student:
select * from student;
然后加上一列序号:
select row_number() over(partition by 1) as xuhao,
a.*
from student a;
得到结果:
转载自:https://blog.csdn.net/qq_40477943/article/details/81873293
现有一个表student:
select * from student;
然后加上一列序号:
select row_number() over(partition by 1) as xuhao,
a.*
from student a;
得到结果:
转载自:https://blog.csdn.net/qq_40477943/article/details/81873293