mysql 查看我的排名

        SELECT b.rownum FROM
        (
            SELECT t.*, @rownum := @rownum + 1 AS rownum FROM (SELECT @rownum := 0) r,
            (
                SELECT * FROM `ko_monthly_exam_ranking` 
                where seriesId = #{seriesId} 
                ORDER BY totalScore DESC,totalTime,lastTime
            ) AS t
        ) AS b WHERE b.employeeNo = #{employeeNo}