查询时能不能显示行号select * from a显示ABC最好是1A2B3C[解决办法]select row_number() over (order by
查询时能不能显示行号
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