SQL之ORDER BY不规则排序.如:中文月份排序
时间:2021-07-01 10:21:17
帮助过:8人阅读
BY
CASE Month
WHEN ‘一月‘ THEN 1
WHEN ‘二月‘ THEN 2
WHEN ‘三月‘ THEN 3
WHEN ‘四月‘ THEN 4
WHEN ‘五月‘ THEN 5
WHEN ‘六月‘ THEN 6
WHEN ‘七月‘ THEN 7
WHEN ‘八月‘ THEN 8
WHEN ‘九月‘ THEN 9
WHEN ‘十月‘ THEN 10
WHEN ‘十一月‘ THEN 11
WHEN ‘十二月‘ THEN 12
END
SQL之ORDER BY不规则排序.如:中文月份排序
标签: