SQL order 排序

select * from emp;

--按照工资升序排序

select * from emp order by sal;

--按照工资降序排序

select * from emp order by sal desc;