mysql-Implementing Line Numbers

At present, MySQL does not support like Oracle RowNum, in the internet also looked for a lot, various ways, their own summary, the implementation method is as follows

New table:

userid	Salay
Zhangsan	10000
Lisi	12000
Wangwu	15000

Now you want to sort by salay and get the corresponding line number, SQL is as follows

select userid,(@rowNum:[email protected]+1)asfromuserjoin (select (@rowNum:=0orderbydesc

The output results are as follows:

RowNo	userid	Salay
1	Wangwu	50000
2	Lisi	12000
3	Zhangsan	10000

mysql-Implementing Line Numbers