-- 限制查询结果数量
-- 查询基本工资最高的前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;