MySql之排序
数据排序
排序(升序、降序)
注意:默认是升序,怎么指定升序或者降序呢?asc表示升序,desc表示降序。
select ename , sal from emp order by sal;//升序
select ename, sal from emp order by asc;//生序
select ename, sal from emp order by desc;//降序
按照工资的降序排列,当工资相同的时候再按照名字额升序排列。
select ename,sal from emp order by sal desc;
select ename,sal from emp order by sal desc ,