The AS operator is used to alias a column name. It can be applied simply to rename the final display table columns, or as a reference name for joins and more complex queries.
Note
The
ASoperator is executed at the end of a query; thus, we cannot use it inWHEREclauses.