You can use an AS clause in a SELECT statement to name or rename a result column in a query. The name must not be qualified and does not have to be unique.
The following example shows the use of an AS clause in a query submitted in Db2® for z/OS®:
SELECT NAME, SALARY*0.05 AS "RAISE" FROM Q.STAFF
If the AS clause is not specified and the result column is derived from a column name, the result column name is the unqualified name of that column.