题解 | #注册当天就完成了试卷的名单第三页#

这道题考察limit

LIMIT (n-1)*m,m 查看第n页数据，每页m条的公式，该部分实际上是LIMIT (3-1)*3,3。 

SELECT
    uid,
    level,
    register_time,
    max_score
FROM
    exam_record
    JOIN examination_info USING (exam_id)
    JOIN user_info USING (uid)
    JOIN (
        select
            uid,
            MAX(score) as max_score
        from
            exam_record
        group by
            uid
    ) as tb using (uid)
WHERE
    submit_time IS NOT NULL
    AND DATE (submit_time) = DATE (register_time)
    AND job = '算法'
    and tag = '算法'
ORDER BY
    max_score DESC
LIMIT
    6, 3;