Neoview SQL Reference Manual (R2.4)

Examples of Derived Column Names
• These two examples show how to use names for derived columns.
The first example shows (EXPR) as the column heading of the SELECT result table:
SELECT AVG (salary)
FROM persnl.employee;
(EXPR)
----------------
49441.52
--- 1 row(s) selected.
The second example shows AVERAGE SALARY as the column heading:
SELECT AVG (salary) AS "AVERAGE SALARY"
FROM persnl.employee;
"AVERAGE SALARY"
----------------
49441.52
--- 1 row(s) selected.
224 SQL Language Elements