mysql - SQL ORDER BY by 内部 ORDER BY

Question

尝试掌握 SQL

我想按日期订购，然后在其中按标题订购。

示例:

SELECT *
FROM tblboek
ORDER BY jr_van_uitgave DESC

如何在按年龄的订单中按头衔排序？

Answer 1

试试这个:

  SELECT * 
    FROM tblboek 
ORDER BY age,   -- First order by age
         title  -- if ages are the same, order by title

在需要时添加DESC，例如如果您想按年龄降序排列:

  SELECT * 
    FROM tblboek 
ORDER BY age desc,  
         title