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