升序
SELECT * FROM emp ORDER BY sal ASC;降序
SELECT * FROM emp ORDER BY sal DESC;使用多列作为排序条件
SELECT * FROM emp ORDER BY sal ASC,comm DESC;DQL（数据查询语言）之排序
发布于 2020-08-13 328 次阅读
发布于 2020-08-13 328 次阅读
SELECT * FROM emp ORDER BY sal ASC;SELECT * FROM emp ORDER BY sal DESC;SELECT * FROM emp ORDER BY sal ASC,comm DESC;
Comments | NOTHING