查找employees里最晚入职员工的所有信息:
SELECT * from employees ORDER BY hire_date desc limit 1;
SELECT * from employees ORDER BY hire_date desc limit 1 offset 0;
limit应用:
SELECT * from employees
where hire_date = (
SELECT hire_date from employees
ORDER BY hire_date desc -- 倒序
limit 2,1); -- 从第二个之后开始取,取一个,也就是倒数第三个
offset应用:
SELECT * FROM employees
WHERE hire_date = (
SELECT hire_date from employees
ORDER BY hire_date desc
limit 1 OFFSET 2 ); -- 去掉排名倒数第一第二的时间,取倒数第三