CALCULATED

Refers to columns already calculated in the SELECT clause.

Syntax

CALCULATED column-alias

Required Argument

column-alias

is the name that is assigned to the column in the SELECT clause.

Details

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.