#DateForumTypeThreadPost
307 Jun 2016 @ 01:15 PDTDatabaseReplyLeast/Greatest Function with Dates select date1, date2, date3, date4, cast(greatest ( cast(COALESCE(date1, date '1900-01-01') AS INT), cast( COALESCE(date2, date '1900-01-01') AS INT), cast( COALESCE(date3,...
203 May 2016 @ 07:43 PDTDatabaseReplyDiff between CTE and Volatile tables in TeradataThanks all for the detailed clarification. @Dave Your example clarifies a lot of confusion I am having about CTE. If you are only going to use the content once then: using cte = 10 seconds, us...
129 Apr 2016 @ 01:14 PDTDatabaseTopicDiff between CTE and Volatile tables in TeradataCan anyone please explain difference between Common Table Expression(CTE)Tables and Volatile tables in which scenario they perform better. As we can create & drop volatile tables as part of ou...