查询时能不能显示行号解决方案

查询时能不能显示行号
select * from a

显示
A
B
C

最好是
1 A
2 B
3 C



[解决办法]
select row_number() over (order by ID),ID from #test
[解决办法]

SQL code

select RN=ROW_NUMBER() OVER (ORDER BY col1),* from a