mysql - 带有复合字段的查询中的 ORDER BY

Question

我有下一个mysql表结构:

++++++++++++++++++++++++++++++++++++
+ id + value + month + year + type +
++++++++++++++++++++++++++++++++++++

我想做下一个选择:

SELECT 
 * 
FROM 
 Table

但是有 ORDER BY 选项。我想对 YEAR-MONTH 复合字段 DESC 的结果进行排序。

我需要这样的东西:

SELECT 
 * 
FROM 
 Table
ORDER BY 
 YEAR-MONTH
DESC

我该怎么做？

Answer 1

SELECT 
    * 
FROM 
    Table
ORDER BY 
    YEAR DESC, 
    MONTH DESC