这种写法怎么改？

[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

[Zi_Yuan]

我确实这个问题只发了一个帖子啊！

[claro]

我记得回复了啊。

[张志峰]

在最后加一个 end

[中国风]

少的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;
這樣寫法效率低；樓主最好把腳本貼完整

[百年树人]

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

一个问题发一个帖子就好了