求一語句.谢谢~

[chuan1985]

以下为原始表格的格式:
列1 列2 列3
1 MTEP1209-0216S TEP12090292
1 MTEP1209-0216S TEP12090288
1 MTEP1209-0216S TEP12090290
2 MTEP1211-0013B TEP13010005
2 MTEP1211-0013B TEP12110060
3 MTSP1211-0030B TSP13040001
3 MTSP1211-0030B TSP12120002
3 MTSP1211-0030B TSP12110032
3 MTSP1211-0030B TSP12110030
如何增加一列为自增的列,如下
列1 列2 列3 列4
1 MTEP1209-0216S TEP12090292 1
1 MTEP1209-0216S TEP12090288 2
1 MTEP1209-0216S TEP12090290 3
2 MTEP1211-0013B TEP13010005 1
2 MTEP1211-0013B TEP12110060 2
3 MTSP1211-0030B TSP13040001 1
3 MTSP1211-0030B TSP12120002 2
3 MTSP1211-0030B TSP12110032 3
3 MTSP1211-0030B TSP12110030 4
请高手指教....

[ws_hgo]

select *,
		row_number() over(partition by 列1 order by 列2) as 行号
from table

[Felixzhaowenzhong]

SELECT *,ROW_NUMBER() OVER(PARTITION BY 列2 ORDER BY 列2)列4 FROM TB

[以学习为目的]

select *, row_number() over(partition by 列1 order by 列2) as 行号
from table

[chuan1985]

谢谢楼上3位,搞定了,谢谢!!!