ORDER BY 子句。SELECT ...... FROM ...... ORDER BY 列名 [ASC | DESC];SELECT ename,sal FROM t_emp ORDER BY sal;SELECT empno,ename,sal,deptno FROM t_emp ORDER BY sal DESC;ASC 代表升序(默认),DESC 代表降序SELECT ename,sal FROM t_emp ORDER BY hiredate DESC;SELECT empno,ename,hiredate,deptno FROM t_emp ORDER BY ename ASC;
SELECT empno,ename,hiredate,deptno FROM t_emp ORDER BY hiredate DESC;ORDER BY 规定首要排序条件和次要排序条件。
数据库会先按照首要排序条件排序,如果遇到首要排序内容相同的记录,那么就会启用次要排序条件接着排序。

SELECT empno,ename,sal,hiredate FROM t_emp ORDER BY sal DESC,hiredate ASC;SELECT
empno,ename,deptno,sal
FROM t_emp
ORDER BY deptno,sal DESC;SELECT
empno,ename,sal
FROM t_emp ORDER BY sal DESC LIMIT 0,5;ORDER BY 子句书写的时候放在 LIMIT 子句的前面
FROM -> SELECT -> ORDER BY -> LIMIT