mysql order by 有重复项，可选参数？

Question

例如， rating 列的所有行的值均为零。 ORDER BY rating DESC 将是主要的，是否有办法进行辅助 ORDER BY。

如果ORDER BY rating DESC有重复项，那么是否ORDER BY name DESC？这可能吗？

---

 id   | name  | rating
  1   | one   |  0
  2   | two   |  0
  3   | three |  0
  4   | four  |  0
  5   | five  |  0
  6   | six   |  0

Answer 1

是的。

只需在 order by 子句中添加第二列

ORDER BY rating DESC, name DESC