Archives of the TeradataForum
Message Posted: Fri, 22 Aug 2008 @ 10:28:39 GMT
Basically give it a name and use the name in subsequent expressions.
select 1 + 2 as sum1, sum1 + 4;
sum1 (sum1+4) 3 7
If you can't afford to have the intermediate result come back to the user - simply do it in a derived table.
Hope this helps
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|