June 21, 2019

WITH clause in Teradata SQL

WITH CTE1 AS (select current_date as today)
select today
from CTE1;

Ref: http://dwgeek.com/teradata-with-clause-syntax-usage-and-examples.html/

No comments:

Post a Comment