SQL top order between 一起使用

select * from emp;

 

--输出工资在[1500,3000]范围之内的工资最高的前5个员工信息

select top 5 * from emp where sal between 1500 and 3000 order by sal desc;