求一語句.多谢

求一語句.谢谢~
以下为原始表格的格式:
列1 列2 列3
1MTEP1209-0216STEP12090292
1MTEP1209-0216STEP12090288
1MTEP1209-0216STEP12090290
2MTEP1211-0013BTEP13010005
2MTEP1211-0013BTEP12110060
3MTSP1211-0030BTSP13040001
3MTSP1211-0030BTSP12120002
3MTSP1211-0030BTSP12110032
3MTSP1211-0030BTSP12110030
如何增加一列为自增的列,如下
列1 列2 列3 列4
1MTEP1209-0216STEP12090292 1
1MTEP1209-0216STEP12090288 2
1MTEP1209-0216STEP12090290 3
2MTEP1211-0013BTEP13010005 1
2MTEP1211-0013BTEP12110060 2
3MTSP1211-0030BTSP13040001 1
3MTSP1211-0030BTSP12120002 2
3MTSP1211-0030BTSP12110032 3
3MTSP1211-0030BTSP12110030 4
请高手指教....

[解决办法]

SQL code

select *,        row_number() over(partition by 列1 order by 列2) as 行号from table
[解决办法]
SQL code
SELECT *,ROW_NUMBER() OVER(PARTITION BY 列2 ORDER BY 列2)列4 FROM TB
[解决办法]
SQL code
select *, row_number() over(partition by 列1 order by 列2) as 行号from table