sel
a,
b,
rank() over(order by c)
from table1
Showing posts with label Teradata. Show all posts
Showing posts with label Teradata. Show all posts
August 14, 2019
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/
Subscribe to:
Posts (Atom)