order by 子句 后面跟 case when 不再是排序
可以理解为分组排序(group by)
比如说,学生排队,凡是姓张的,我们给他们贴个标签“1”,凡是姓李的,我们给他们贴个标签“2”,凡是姓王的,我们给他们贴个标签“3”。然后按照 1 2 3 排序
select plannum,fixednum,forenum,PZXS,DimProduct,demo
from vs_WeekPlanline where foreNum is not null
order by case DimProduct
when '方太吸油烟机' then 1
when '方太消毒柜' then 2
when '方太灶具' then 3
when '方太热水器' then 4
when '米博热水器' then 5
when '方太微波炉' then 6
when '方太烤箱' then 7
when '方太蒸箱' then 8
when '方太洗碗机' then 9
when '方太电蒸锅' then 10
when '方太保温箱' then 11 else 12 end,plannum desc