关于排序的问题，高手来看一下吧，谢谢了
比如表table
字段id ,name,age,city

select name from table
where age in (20,21,22,23,24)
or city in( beijing,shanghai,shenzhen)

我如何让age是22排在前面
或者让age是22的又是北京的排在前面

我这现在默认是按id排的

[解决办法]
select name from table
where age in (20,21,22,23,24)
or city in( beijing,shanghai,shenzhen)
order by case when age=22 then -1 else id end
--order by case when age=22 and city= 'beijing ' then -1 else id end

[解决办法]
order by case when age=22 then 1 else 2 end