sql排序问题 受累帮忙!! 在线等

[tss1011]

这是一个查询出的结果集

memo                      a       b      c

Assets                    0       0      0
Number of clients         0       0      0
Number of deals           0       0      0
Revs                      0       0      0
Sales                     0       0      0

现在想要结果是这个样子的

memo                      a       b      c

Number of clients         0       0      0 
Number of deals           0       0      0
Assets                    0       0      0
Sales                     0       0      0 
Revs                      0       0      0

除了用union all的方法 用排序能实现么?? 高手帮忙解决 谢谢

[dobear_0922]

order by len(memo) desc

[sunhonglei2004]

没有看出为你的排序规则是什么，难道是memo列的长度？

select * from tb order by len(memo) desc

[tss1011]

高手都去哪了啊....5555

[jackyerror]

讲清楚你想要的排序规则先

[一者仁心]

declare @tab table
(
a varchar(200),
b int,
c int
)
insert into @tab select 'assets' ,0,0
union all select 'Number of c',0,0
union all select 'Number of d',0,0
union all select 'revs',0,0
union all select 'sales',0,0


select * from @tab order by substring(a,4,1)

取巧了

[you_tube]

你的排序规则 是什么？？？

[ojuju10]

select * from tb
order by (case when memo='Number of clients' then 1
when memo='Number of deals' then 2
when memo='Assets' then 3
when memo='Sales' then 4
when memo='Revs' then 5
else 6 end
) asc

[tss1011]

按列的长度倒也是个好方...谢了

[tss1011]

不过问题要是结果是这样怎么办呢?

memo                      a       b      c

Number of deals           0       0      0 
Number of clients         0       0      0
Assets                    0       0      0
Sales                     0       0      0 
Revs                      0       0      0

[Lexi Meng]

不知所云！！

[dobear_0922]

不过问题要是结果是这样怎么办呢?

order   by   (case memo when   'Number of clients'   then   2 
        when 'Number of deals' then   1 
        when 'Assets' then   3 
        when 'Sales' then   4 
        when 'Revs' then   5 
        else 6 end 
) 

[pastbee]

提问一塌糊涂,什么问题?说清楚