排序查询
语法:
order by 字段 desc; 降序
order by 字段 asc; 升序(默认升序)
案例1:
SELECT * FROM employees ORDER BY salary DESC;
SELECT * FROM employees ORDER BY salary ASC;
注意:多个字段排序,按照优先顺序,先排序靠前的字段,然后在相同的基础上再排序
案例2:查询员工信息,先按照工资升序,再按照员工编号降序
SELECT employee_id,salary
FROM employees
ORDER BY salary ASC,employee_id DESC
LIMIT 10; --只查询前10条记录