mysql 查询某一用户的排名,由于mysql没有rownum,查询排名就比较麻烦了,所以记录下
SELECT count(1) AS rank_num,
FROM tab_game_rank
WHERE pnumber >= (SELECT pnumber
FROM tab_game_rank
WHERE uid = 3)
rank_num 排名
pnumber 排名字段
uid 用户id
mysql 查询某一用户的排名,由于mysql没有rownum,查询排名就比较麻烦了,所以记录下
SELECT count(1) AS rank_num,
FROM tab_game_rank
WHERE pnumber >= (SELECT pnumber
FROM tab_game_rank
WHERE uid = 3)
rank_num 排名
pnumber 排名字段
uid 用户id