这种写法怎么改？

[Zi_Yuan]

前面语句就不要管了，只错在后面，描红的地方有错，怎么改？谢谢！
order by
case
when (
select count(*) from caiwu
where acc_level=2 and parent_id<>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='资产类')
)>=
(
select count(*) from caiwu
where acc_level=2 and parent_id<>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='负债类及所有者权益类')
)
then x.acc_xh
when (
select count(*) from caiwu
where acc_level=2 and parent_id<>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='资产类')
)<=
(
select count(*) from caiwu
where acc_level=2 and parent_id<>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='负债类及所有者权益类')
)
then y.acc_xh

[ks_reny]

我從來沒有這么寫過,要是這么複雜,我就寫成視圖了,然後對視圖的欄位進行排序.

[Zi_Yuan]

我就不想弄成视图，在数据库里乱七八糟的一些东西，链接过来链接过去的
难道弄成视图，效率就会高了吗？我觉得应该一样吧

[claro]

讨论

[PrewinZZZ]

end as 'columnName'？

[PrewinZZZ]

确实效率很低！

[Zi_Yuan]

那么应该怎么写，效率就会高了？

[Zi_Yuan]

好了。忘写end了

[百年树人]

order by
case
when (
select count(*) from caiwu
where acc_level=2 and parent_id <>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='资产类')
)>=
(
select count(*) from caiwu
where acc_level=2 and parent_id <>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='负债类及所有者权益类')
)
then x.acc_xh
when (
select count(*) from caiwu
where acc_level=2 and parent_id <>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='资产类')
) <=
(
select count(*) from caiwu
where acc_level=2 and parent_id <>0 and valid=1 and parent_id=(select acc_id from caiwu where acc_name='负债类及所有者权益类')
)
then y.acc_xh end

[中国风]

少的end;
這樣寫法效率低；樓主最好把腳本貼完整

[dawugui]

[Quote=引用 1 楼 Zi_Yuan 的回复:]
好了。忘写end了
[/Quote]忘写end了?

[水族杰纶]

case when end

[Zi_Yuan]

[Quote=引用 3 楼 roy_88 的回复:]
少的end;
這樣寫法效率低；樓主最好把腳本貼完整
[/Quote]
为什么效率底？