AS

The keyword that gives a column, expression or table a new name in a query.

In more detail

Name every computed column with AS, or its heading becomes the expression text itself and any program reading it by name breaks when the spacing changes. The same keyword can name a table in FROM, where it is optional.

Example

price_cents * stock AS stock_value_cents

Related terms

Taught in

References