升序
SELECT * FROM emp ORDER BY sal ASC;
降序
SELECT * FROM emp ORDER BY sal DESC;
使用多列作为排序条件
SELECT * FROM emp ORDER BY sal ASC,comm DESC;
发布于 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