The SQL Procedure

CALCULATED

Refers to columns already calculated in the SELECT clause.

CALCULATED column-alias

column-alias is the name assigned to the column in the SELECT clause.

Referencing a CALCULATED Column
CALCULATED enables you to use the results of an expression in the same SELECT clause or in the WHERE clause. It is valid only when used to refer to columns that are calculated in the immediate query expression.

Chapter Contents
Previous
Next
Top of Page