Previous Page | Next Page

The SQL Procedure

CALCULATED


Refers to columns already calculated in the SELECT clause.
CALCULATED column-alias


Argument

column-alias

is the name that is 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.

Previous Page | Next Page | Top of Page