SELECT
cityname
FROM
( SELECT DISTINCT cityname FROM 城市表 ) A
ORDER BY
CASE
WHEN a.cityname='全国' THEN
1
WHEN a.cityname='北京' THEN
2
WHEN a.cityname='上海' THEN
3
WHEN a.cityname='广州' THEN
4
WHEN a.cityname='深圳' THEN
5
END
通过 case when 进行排序
最新推荐文章于 2023-11-30 14:24:05 发布