Hello people.
Since I could not find anything on Google, here is my simple question:
How can I use column alias in a UNION query. it seems that if I specify the alias it will not be displayed.
Ex:
SELECT * FROM
(
SELECT SYSDATE FROM DUAL
UNION ALL
SELECT SYSDATE FROM DUAL
) TEST;
Column alias TEST will not be used.
Thank you in advance.