紧急求助！SQL排列问题

[Small__Wolf]

Select '梁XX' as '客户名称','680000.000000' as '累计消费金额' ,'张XX' as '第一展员','100000.000000' as '回款金额','昌XX' as '第二展员','100000.000000' as '回款金额','赵XX' as '第三展员','50000' as '回款金额','' as '第四展员','' as '回款金额'
union all
Select '梁XX' as '客户名称','680000.000000' as '累计消费金额' ,'赵XX' as '第一展员','50000.000000' as '回款金额','张XX' as '第二展员','20000.000000' as '回款金额','昌XX' as '第三展员','10000' as '回款金额','' as '第四展员','' as '回款金额'
union all
Select '梁XX' as '客户名称','680000.000000' as '累计消费金额' ,'昌XX' as '第一展员','10000.000000' as '回款金额','赵XX' as '第二展员','50000.000000' as '回款金额','张XX' as '第三展员','90000' as '回款金额','' as '第四展员','' as '回款金额'
union all
Select '梁XX' as '客户名称','680000.000000' as '累计消费金额' ,'赵XX' as '第一展员','10000.000000' as '回款金额','昌XX' as '第二展员','10000.000000' as '回款金额','张XX' as '第三展员','180000' as '回款金额','' as '第四展员','' as '回款金额'

union all
Select '方XX' as '客户名称','680000.000000' as '累计消费金额' ,'AAA' as '第一展员','10000.000000' as '回款金额','BBB' as '第二展员','50000.000000' as '回款金额','CCC' as '第三展员','90000' as '回款金额','' as '第四展员','' as '回款金额'
union all
Select '方XX' as '客户名称','350000.000000' as '累计消费金额' ,'AAA' as '第一展员','10000.000000' as '回款金额','BBB' as '第二展员','10000.000000' as '回款金额','CCC' as '第三展员','180000' as '回款金额','' as '第四展员','' as '回款金额'


统计客户对于的展员信息，按照展员金额大小从左到右依次排列

要求输出下面的结果 ，参考http://topic.csdn.net/u/20120711/14/07725cdc-0c52-4a4c-894e-23506efad492.html?seed=414647155&r=79094610#r_79094610


Select '梁XX' as '客户名称','680000.000000' as '累计消费金额' ,'张XX' as '第一展员','390000.000000' as '回款金额','赵XX' as '第二展员','160000.000000' as '回款金额','昌XX' as '第三展员','130000.000000' as '回款金额','' as '第四展员','' as '回款金额'
UNION ALL
Select '方XX' as '客户名称','350000.000000' as '累计消费金额' ,'CCC' as '第一展员','270000.000000' as '回款金额','BBB' as '第二展员','60000.000000' as '回款金额','AAA' as '第三展员','20000.000000' as '回款金额','' as '第四展员','' as '回款金额'

[shoppo0505]

这都算是啥问题啊？
要不试试这个？

Select * from tablename
where '梁XX' = '客户名称' and '680000.000000' = '累计消费金额' and'张XX' = '第一展员'and'390000.000000' = '回款金额'and'赵XX' = '第二展员'and'160000.000000' = '回款金额'and'昌XX' = '第三展员'and'130000.000000' = '回款金额'and'' = '第四展员'and'' = '回款金额'
UNION ALL
Select  * from tablename
where '方XX' = '客户名称' and '350000.000000' = '累计消费金额' and'CCC' = '第一展员'and'270000.000000' = '回款金额'and'BBB' = '第二展员'and'60000.000000' = '回款金额'and'AAA' = '第三展员'and'20000.000000' = '回款金额'and'' = '第四展员'and'' = '回款金额'