我使用下面的代码来查找max movies的演员，但是我现在需要第三个演员:
SELECT CONCAT_WS(" ",actor.first_name,actor.last_name) AS Full_name
FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id
GROUP BY actor.actor_id
ORDER BY count(film_actor.actor_id) DESC
LIMIT 1;
您可以将第二个值传递给LIMIT，该值指示查询的偏移量。 传递2作为偏移量，传递1作为限制，将只得到第三行。
SELECT CONCAT_WS(" ",actor.first_name,actor.last_name) AS Full_name
FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id
GROUP BY actor.actor_id
ORDER BY count(film_actor.actor_id) DESC
LIMIT 2, 1;
