Renaming Columns

The AS clause allows for columns to be aliased or renamed in a query.

Syntax

SELECT <column> AS <alias> FROM <table>;

Example

SELECT name AS Company FROM Companies;