Q&A BY TAG 'CTE'

You must sign in to ask a question. If you do not have an account, you can register here

Common Table Expression (CTE) and Recursion
answered 18-08-2021 04:59:45 -0400

I see there is support of WITH statements allowing CTE work. Does Denodo support recursion in CTE's? I have tried to get it working, but the error back is that the name of the CTE does not exist. When I remove the recursion piece of the query, it wo...

Answers: 3

CTE Recursion

Disadvantage of using multiple CTEs in Denodo
answered 22-09-2020 17:48:01 -0400

We are using many level of CTEs in our architeture.Also joining them with other integrated views.Please let me know what are the disadvantages of using CTEs in Denodo considering performance side.

Answers: 1

CTE

Using CTE WITH clause for creating base view from query
answered 12-04-2018 09:19:08 -0400

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Answers: 3

Base view quer cte MSSQL

Multiple created values in a CTE
answered 03-10-2017 05:02:17 -0400

Good afternoon, I am trying to use a CTE with multiple values. ie: ;with pd as ( select '12345' ) But I need a large amount of values, and am not sure of the syntax needed to do multiple select's in a CTE in this manner. So I would need 12345, 1234...

Answers: 1

CTE

Limit inside Denodo common table expression
answered 02-05-2017 09:49:05 -0400

Is it possible to limit VQL query output inside common table expressions? I mean something like that: "DenodoTable" hh order by "holding" desc **--LIMIT 10** ) select * from cte If uncomment "LIMIT 10', above VQL gives "Syntax error: Exception par...

Answers: 1

Top N CTE Limit

WITH (COMMON TABLE EXPRESSIONS) Denodo Express 6.0
answered 06-03-2017 06:25:45 -0500

According to your VDP Conformance with Standard SQL document: COMMON TABLE EXPRESSIONS are supported in Denodo 6. Does this apply to Denodo Express as well? My base view fails with the following error: ICTE_TEST_SECOND [BASE] [ERROR] CTE_TEST_SECOND [J...

Answers: 1
Related to: VDP Conformance with Standard SQL

CTE