| 备注 | 修改日期 | 修改人 |
| CREAT | 2021-05-19 14:40:16[当前版本] | 系统管理员 |
表 a：
| UID | Money |
| 2 | 444 |
| 1 | 222 |
| 3 | 555 |
| 4 | 6666 |
想要以Money排序取得排行号：SQL文如下：
Select UID,(@rowNum:=@rowNum+1) as rowNo
From a,
(Select (@rowNum :=0) ) b
Order by a.Money Desc
输入结果如下：
| UID | rowNo |
| 4 | 1 |
| 3 | 2 |
| 2 | 3 |
| 1 | 4 |
