利用sql进行排名 查询排名 SELECT a.* FROM ( SELECT *,( @i := @i + 1 ) AS NO FROM tbj_user, ( SELECT @i := 0 ) AS it ORDER BY fx_renshu DESC ) AS a WHERE a.id = 100