MySQL Gets the line number of the query record

For the ability to get the line number of a query record, Oracle can use the standard method (above version 8i) or use nonstandard Rownum,ms SQL Server to provide the row_number () function in version 2005. But in MySQL there seems to be no such system comes with function = =! It's tragic.

Fortunately, the power of folk is always strong, we can construct a similar function ourselves!

Table A:
Uidmoney
2444
1222
3555
46666
To get a ranking number in Money order: SQL reads as follows:

Select UID, (@rowNum: [email protected]+1) as RowNo
From A,
(Select (@rowNum: =0)) b
Order by A.money Desc

The input results are as follows:

Uidrowno
41
32
23
14

MySQL Gets the line number of the query record