废话不多说,上代码 SELECT k FROM ( SELECT 'shanghai' AS k FROM DUAL UNION ALL SELECT 'dalian' AS k FROM DUAL UNION ALL SELECT 'beijing' AS k FROM DUAL ) ORDER BY CASE WHEN k = 'beijing' THEN 1 WHEN k = 'dalian' THEN 3 WHEN k = 'shanghai' THEN 2 END 利用ORDER BY 的case语句配置排序顺序号. 当然利用利用查询子表,或union等方式也可以,但是这个可以说是最简单,最高效方法.