带有 LIMIT 子句的 SELECT 语句的基本语法如下:
SELECT column1, column2, columnN FROM table_name LIMIT 5
#结果条数限制5条#
下面是 LIMIT 子句与 OFFSET 子句一起使用时的语法:
SELECT column1, column2, columnN FROM table_name LIMIT 1 OFFSET 3
#结果条数从第4条开始取一条#
同理可换成:ORDER BY hire_date DESC limit 3,1
从第4条开始取一条
select * from employees where hire_date =(
select distinct hire_date from employees order by hire_date desc limit 1 offset 2)
