SQL对汉字月份进行排序的两种方法

1

SELECT MONTH FROM aa ORDER BY MONTH

SELECT month FROM aa ORDER BY month

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

SELECT MONTH
FROM aa ORDER 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
ELSE 99 END

SELECT month FROM aa ORDER 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 ELSE 99 END

1
2
3
4

SELECT MONTH 
FORM  aa
ORDER BY  
CHARINDEX (MONTH,'一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月')

SELECT month FORM aa ORDER BY CHARINDEX (month,'一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月')