SQL 行专列 顺序要从小到大排列

max(case kongnum when '2' then baifenbi else 0 end) as '2',
max(case kongnum when '3' then baifenbi else 0 end) as '3',
max(case kongnum when '4' then baifenbi else 0 end) as '4',
max(case kongnum when '5' then baifenbi else 0 end) as '5',
max(case kongnum when '1' then baifenbi else 0 end) as '1',
这是我动态生成的；2、3、4、5、1
我想请教下 怎么让他生成1、2、3、4、5 如下：
max(case kongnum when '1' then baifenbi else 0 end) as '1',
max(case kongnum when '2' then baifenbi else 0 end) as '2',
max(case kongnum when '3' then baifenbi else 0 end) as '3',
max(case kongnum when '4' then baifenbi else 0 end) as '4',
max(case kongnum when '5' then baifenbi else 0 end) as '5',
求原因 求帮助 求语句

http://www.jb51.net/article/48335.htm