oracle SQL先按字母排序再按数字排序
SELECT
YMFROM,
(
CASE
WHEN ASCII (YMFROM) BETWEEN 65
AND 122 THEN
YMFROM
END
) AS YM1,
(
CASE
WHEN ASCII (YMFROM) < 65
or ASCII (YMFROM) > 122 THEN
YMFROM
END
) AS YM2
FROM
D_BZGFMX
ORDER BY
YM1...
原创
2019-11-01 15:50:12 ·
1851 阅读 ·
0 评论