有一表
-----------------
COL1 COL2 COL3
-----------------
aabaa 111 20.3
bbasdb 111 30.5
cccasd 121 40.6
asdf 121 10.3
ads 123 10.5
ade 123 10.5
ads 505 11.55
ads 505 125
adx 606 15想得到的结果
---------------
COL1 COL2 COL3 序号
----------------------
aabaa 111 20.3 1
bbasdb 111 30.5 2
cccasd 121 40.6 1
asdf 121 10.3 2
ads 121 10.5 3
ade 123 10.5 2
ads 505 11.55 1
ads 505 125 2
adx 606 15 1
-----------------
COL1 COL2 COL3
-----------------
aabaa 111 20.3
bbasdb 111 30.5
cccasd 121 40.6
asdf 121 10.3
ads 123 10.5
ade 123 10.5
ads 505 11.55
ads 505 125
adx 606 15想得到的结果
---------------
COL1 COL2 COL3 序号
----------------------
aabaa 111 20.3 1
bbasdb 111 30.5 2
cccasd 121 40.6 1
asdf 121 10.3 2
ads 121 10.5 3
ade 123 10.5 2
ads 505 11.55 1
ads 505 125 2
adx 606 15 1
TB
row_number() over (partition by COL2 order by COL1)
from tablename
SELECT
*,
rowno = ROW_NUMBER() OVER(PARTITION BY col2 order BY GETDATE())
FROM #temp
*,row_number() over (partition by COL2 order by col1) as 序号
from
tb
row_number() over (partition by COL2 order by COL3)
from tablename