请问怎么同时将3个字段自定义排序,如果只根据“部门类别”排序我会写
order by
CASE WHEN Department_1='北京BG' THEN 1
WHEN Department_1='TS数字BG' THEN 2
WHEN Department_1='集团' THEN 3
WHEN Department_1='媒介中心' THEN 4
WHEN Department_1='深圳BG' THEN 5
end
但是想把“一级部门”和“核算单元”两个字段也自定义排序应该怎么写呀?
继续加case
,case when Department_2=XXX then 1 ............. end
case when Department_3=XXX then 1 ............. end
一样再写,继续写就可以
end as Department_1_new,
CASE WHEN Department_2='XXX' THEN 1
WHEN Department_2='XXX1' THEN 2
WHEN Department_2='XXX2' THEN 3
WHEN Department_2='XXX3' THEN 4
WHEN Department_2='XXX4' THEN 5
end as Department_2_new
在外面在套一层select
select * from (
select
end num
from 表
) a
order by num