#按照salary从低到高的顺序显示员工信息SELECT employee_id,last_name,salary
FROM employees
ORDERBY salary ASC;SELECT employee_id,last_name,salary
FROM employees
#如果在ORDER BY 后没有显式指名排序的方式的话,则默认按照升序排列。ORDERBY salary;
#按照salary从高到低的顺序显示员工信息SELECT employee_id,last_name,salary
FROM employees
ORDERBY salary DESC;
#可以使用列的别名,进行排序SELECT employee_id,salary,salary *12 annual_sal
FROM employees
ORDERBY annual_sal;
#列的别名只能在 ORDER BY 中使用,不能在WHERE中使用。#因为WHERE加载的比SELECT要早就找不到annual_sal SELECT employee_id,salary,salary *12 annual_sal
FROM employees
WHERE annual_sal >81600;