select ROW_NUMBER() OVER (ORDER BY column_name) AS ‘row_Number’ from table_name where condition;
07-05
4996
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-24
2578
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
select ROW_NUMBER() OVER (ORDER BY column_name) AS ‘row_Number’ from table_name where condition;