sql语句的小问题，精简一下sql语句

[reallijin]

select id ,sortname,leijibie,(select count(1) from li_item b where isnull(lei1,name)=isnull(a.id,a.sortname) ) from li_sort a where parentid = '0' ORDER BY (select count(1) from li_item where isnull(lei1,name)=isnull(a.id,a.sortname) ) DESC
-------------------------------------
出现了两次 (select count(1) from li_item b where isnull(lei1,name)=isnull(a.id,a.sortname) )

请问用什么参数或数值代替另一个地方？

[cd731107]

select id ,sortname,leijibie,
排序名称=(select count(1) from li_item b where isnull(lei1,name)=isnull(a.id,a.sortname) ) 
from li_sort a where parentid = '0' ORDER BY 排序名称 DESC

[reallijin]

高手呀，你太厉害了！时间不到呢，到了时间给你分。哈哈