select *,len(T) from ( SELECT 城市 , ( SELECT COUNT(*) + 1 FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) E WHERE E.数量汇总 > A.数量汇总 ) AS T FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) A) as TB
select *,len(T) from(SELECT 城市 , ( SELECT COUNT(*) + 1 FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) E WHERE E.数量汇总 > A.数量汇总 ) AS T , --这个LEN(T)是用来测试的,其他的也不行 LEN(T) FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) A) x
from (
SELECT 城市 , ( SELECT COUNT(*) + 1 FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) E WHERE E.数量汇总 > A.数量汇总 ) AS T FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) A) as TB
from(SELECT 城市 ,
( SELECT COUNT(*) + 1 FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) E WHERE E.数量汇总 > A.数量汇总 ) AS T , --这个LEN(T)是用来测试的,其他的也不行 LEN(T) FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) A) x
len( SELECT COUNT(*) + 1 FROM ( SELECT 城市 , SUM(销售数量) AS 数量汇总 FROM killsoft.dbo.[手机销售$] GROUP BY 城市 ) E WHERE E.数量汇总 > A.数量汇总 )