将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 ?

有人可以帮我吗?

预先感谢， 马尼拉西那.

Thanks in advance, Manirathinam.

推荐答案

递归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屋！