mysql记录集中记录序号,MySQL中实现rownum功能类似的语句

1.查询数据排序

select * from pa_sm_score order by score desc

表内容：

 

 

2.mysql记录集中记录序号,MySQL中实现rownum功能类似的语句：

SELECT @rownum:=@rownum+1 rownum,s.* FROM  (SELECT @rownum:=0) r,pa_sm_score s order by score desc

表数据

 

3.查询定位某条记录的记录位置

select t.* from (SELECT @rownum:=@rownum+1 rownum,s.* FROM  (SELECT @rownum:=0) r,pa_sm_score s order by score desc) t,pa_sm_score s where  t.employee_id=s.employee_id  and s.employee_id = 52788