查找employees里入职员工时间排名倒数第三的员工所有信息
SELECT b.emp_no,birth_date,first_name,last_name,gender,hire_date FROM
(
SELECT t.*, @rownum := @rownum + 1 AS rownum
FROM (SELECT @rownum := 0) r,
(SELECT * FROM employees ORDER BY hire_date DESC) AS t
) AS b WHERE b.rownum = 3;