Teradata allows to use fields from SELECT block in other blocks.
A have two tables T1 and T2. And there is a field "a" in table T1 and in T2. And i made a new field in select block^
case when T1.a > T2.a then T1.a else T2.a end AS a
and I want to use this "a" in qualify block. I don't want to write this case again. How can I do it? Are there any special alias for fields from SELECT block?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.