How does one reference another column in the same select statement by alias?
for example in:
Select (1 + 2) as mysum, (mysum*2) as doublemy um”
seems to cause an error.
My problem is that i have some very complex expressions and I need to be able to refer to their value repeatedly…
Thanks,!