Hi,
Is there a way to avoid re-writing common sub-expressions in SELECTs?
For instance, suppose you have:
SELECT ...complex expression..., ...same complex expression...+1
FROM ...
This could be written as a nested SELECT:
SELECT x.value, x.value+1
FROM
(SELECT ...complex expression... value FROM ...) x
Are there any other techniques available?