有表:
a1 a2
A 45
A 34
A 67
B 56
B 34
C 23
D 1
D 67现在要新增加a3列,要求对于同一个a1来说,a2从小到大排序,并在a3中从1开始显示,操作后得a1 a2 a3
A 45 2
A 34 1
A 67 3
B 56 2
B 34 1
C 23 1
D 1 1
D 67 2请问代码如何,谢谢!
a1 a2
A 45
A 34
A 67
B 56
B 34
C 23
D 1
D 67现在要新增加a3列,要求对于同一个a1来说,a2从小到大排序,并在a3中从1开始显示,操作后得a1 a2 a3
A 45 2
A 34 1
A 67 3
B 56 2
B 34 1
C 23 1
D 1 1
D 67 2请问代码如何,谢谢!
from ta a
order by a1,a3
from 表 as a