SQL自定义排序
SELECT * FROM Citys
ORDER BY
CASE WHEN City='北京' THEN 1
WHEN City='天津' THEN 2
WHEN City='上海' THEN 3
WHEN City='重庆' THEN 4
WHEN City='广州' THEN 5
END
SELECT a.City,a.Population,a.GDP FROM
(
SELECT 1 Num,* FROM Citys WHERE City='北京'
UNION ALL
SELECT 2 Num,* FROM Citys WHERE City='天津'
UNION ALL
SELECT 3 Num,* FROM Citys WHERE City='上海'
UNION ALL
SELECT 4 Num,* FROM Citys WHERE City='重庆'
UNION ALL
SELECT 5 Num,* FROM Citys WHERE City='广州'
) a
ORDER BY a.Num
SELECT a.* FROM Citys a
JOIN Temp b ON a.City=b.City
ORDER BY b.Num
——End——
相关文章