-- 限制查询结果数量
-- 查询基本工资最高的前5位员工
select * from emp order by sal desc limit 5;

select * from emp order by sal desc limit 0,5;

-- 查询基本工资第6到10名的员工
select * from emp order by sal desc limit 5,5;

-- 练习：查询最后入职的5位员工
select * from emp order by hiredate desc limit 5;