朴实！简单！依你所好，MySQL排序查询ORDER BY

SELECT
  查询列表
FROM
  表
#可选（WHERE ...）
ORDER BY
  排序列表 DESC/ASC;

SELECT
  *
FROM
  employees
ORDER BY
  salary DESC;

SELECT
  last_name,salary*12*(1+commission_pct) AS 年薪
FROM
  employees
ORDER BY
  年薪 DESC;
#上一行的“年薪”也可以换成最上面那个表达式

SELECT
  LENGTH(last_name) AS 名字长度,last_name,salary*12*(1+IFNULL(commission_pct,0)) AS 年薪
FROM
  employees
ORDER BY
  名字长度 DESC;

#先按照年薪降序，再员工ID升序
SELECT
  employee_id AS 员工ID,last_name AS 名字,salary*12*(1+IFNULL(commission_pct,0)) AS 年薪
FROM
  employees
ORDER BY
  年薪 DESC,员工ID ASC;