排序查询
SELECT 查询列表
FROM 表
WHERE 筛选条件
ORDER BY 排序列表asc|DESC
查询员工信息,要求工资从高到低排序:
SELECT * FROM namelist ORDER BY salary DESC;
查询员工信息,要求工资从低到高排序:
SELECT * FROM namelist ORDER BY salary ASC;
SELECT * FROM namelist ORDER BY salary;
查询部门编号>=5的员工信息要求按年龄排序:
SELECT *FROM namelist WHERE id>=5 ORDER BY age DESC;
按年薪高低显示员工信息和年薪(12*月薪):(按表达式排序)
SELECT *,12*IFNULL(salary,0) AS '年薪' FROM namelist ORDER BY 12*IFNULL(salary,0) DESC;
SELECT *,12*IFNULL(salary,0) AS '年薪' FROM namelist ORDER BY '年薪' DESC;
order by 子句一般放在最后面,limit子句除外。