ORDER BY 后可加2个字段,用英文逗号隔开。 column1 升序, column2 降序,sql该这样写 ORDER BY column1, column1 DESC 也可以这样写,但是更具可读性: ORDER BY column1 ASC, column2 DESC 如果都是降序,则必须用两个desc ORDER BY column1 DESC, column2 DESC