比如表A有两列name,password
测试数据如下:
name password
aa 123
bb 456
cc 789现在要写一条select 语句,得到以下的结果:
No name password
1 aa 123
2 bb 456
3 cc 789就是说在前面加一个自动识别有多少条记录的列
谢谢各位!在线等待
测试数据如下:
name password
aa 123
bb 456
cc 789现在要写一条select 语句,得到以下的结果:
No name password
1 aa 123
2 bb 456
3 cc 789就是说在前面加一个自动识别有多少条记录的列
谢谢各位!在线等待
name, password
from a
order by name
(select count(1) from a where name<=t.name)
name,
password
from a t
order by name
(select count(1) from a where name<=t.name) as No
name,
password
from a t
order by name
select row_number() over(order by name) as No,name,password
from A