hello_小宇的博客

select count(1) as 排名 from 表名 where 分数字段 >= (select 分数字段 from 表名 where 姓名字段 = '用户名') 微擎写法 $uscore = pdo_fetch("SELECT score FROM ".tablename('game_list')." WHERE open_id = :open_id LIMIT 1", a

select name,score,round from (select * from sqlTest order by score desc) as tab group by name having round= 1 order by score desc,name;