大佬教程收集整理的这篇文章主要介绍了雪花 - 不能嵌套在另一个窗口函数中,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
SELECT BEST_CAv_bUSInesS_UNIt_name,SCMS_name,SUM(@R_87_10586@L_ACV - MulTI_YEAR_COMPONENT_OF_ACV) OVER (PARTITION BY BEST_CAv_bUSInesS_UNIt_name,QUARTER_WITH_YEAR) AS Bookings_Net,ROW_numbER() OVER (ORDER BY Bookings_Net desc)
FROM SBG_DB.SBG_SBGIOPS_BV.bV_Security_SUBSCRIPTION_top_CUSTOMERS_FOR_ACV
where EDITION IS NOT NulL
AND BEST_CAv_bUSInesS_UNIt_name IS NOT NulL
AND (NEW_ACV <> 0 OR RENEW_acv <> 0 AND @R_87_10586@l_acv <> 0)
AND QUARTER_WITH_YEAR IN ('20213')
ORDER BY Bookings_Net DESC
对于上述查询,我收到以下错误
“不能嵌套在另一个窗口函数中” - 编译错误
试试这个:
SELEct
*,ROW_numbER() OVER (ORDER BY Bookings_Net desc)
from
(
SELECT
BEST_CAv_bUSInesS_UNIt_name,SCMS_NAME,SUM(@R_87_10586@L_ACV - MULTI_YEAR_COMPONENT_OF_ACV) OVER (PARTITION BY BEST_CAv_bUSInesS_UNIt_name,QUARTER_WITH_YEAR) AS Bookings_Net
FROM
SBG_DB.SBG_SBGIOPS_BV.bV_SECURITY_SUBSCRIPTION_TOP_CUSTOMERS_FOR_ACV
where
EDITION IS NOT NULL
AND BEST_CAv_bUSInesS_UNIt_name IS NOT NULL
AND (NEW_ACV <> 0 OR RENEW_acv <> 0 AND @R_87_10586@l_acv <> 0)
AND QUARTER_WITH_YEAR IN ('20213') )
ORDER BY Bookings_Net DESC
以上是大佬教程为你收集整理的雪花 - 不能嵌套在另一个窗口函数中全部内容,希望文章能够帮你解决雪花 - 不能嵌套在另一个窗口函数中所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。