I was trying to understand how to use the WITH clause and the purpose of the WITH clause.
All I understood was, the WITH clause was a replacement for normal sub-queries.
Can anyone explain this to me with a small example in detail ?
I was trying to understand how to use the WITH clause and the purpose of the WITH clause.
All I understood was, the WITH clause was a replacement for normal sub-queries.
Can anyone explain this to me with a small example in detail ?
with tbldetail as
(
select top 10 *
from POline
)
select *
from tbldetail ;
It is working on SQL but not working on teradata giving me error message.
Failed to execute SQL: Parse Error splitting statement.
Does sql run it with caluse ?