将 SQL Server 中的递归 CTE 转换为 netezza [英] Convert a Recursive CTE in SQL Server to netezza

问题描述

我有一个要求，比如我需要将 sql server 中的递归 CTE 转换为 netezza！

I have a requirement like i need to convert a recursive CTE in sql server into netezza !

netezza 会支持递归 CTE 吗?

Will netezza even support Recursive CTE ?

谁能帮我解决这个问题?

Can anyone help me on this ?

提前致谢，马尼拉蒂南.

Thanks in advance, Manirathinam.

推荐答案

从 7.2 版开始，Netezza 不支持递归 CTE.如果您能告诉我们您在特定情况下要完成的工作，我们可能会提供解决方法/重写.

Recursive CTEs are not supported in Netezza as of version 7.2. If you can tell us what you are trying to accomplish in your particular case, we might be able to offer a workaround/rewrite.

这篇关于将 SQL Server 中的递归 CTE 转换为 netezza的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！