Regarding the limitation of Derived table using With clause-

Database
Enthusiast

Regarding the limitation of Derived table using With clause-

hi teradata experts,

In my Project,(in most of the teradata queries ) i am using one Derived table (using With clause) 

which is attached to Main query, which is very good in terms of performance and implementation

as it takes spool space only one time however it can be used any number of times in the main

query.

but the issue is that there is a limitation of using only one derived table using WIth clause.

Is there any way out that we can use more than one derived tables?

thanks!

Nishant

1 REPLY
Enthusiast

Re: Regarding the limitation of Derived table using With clause-

Hi all,

I got my answer... Good news is that teradata 14 is providing the flexibility of using the 2 WITH clauses in SQL.

Cheers !

Nishant