Creating Column Aliases with AS
In the query results so far, I’ve allowed the DBMS to use default values for column headings. (A column’s default heading in a result is its original column name in its source table). You can use the AS clause to create a column alias. A column alias is an alternative name (identifier) that you specify to control how column headings are displayed in a result. Use column aliases if column names are cryptic, hard to type, too long, or too short.
Specify column aliases in the SELECT clause of a SELECT statement: Follow a column name with the AS keyword and an alias enclosed in single or double quotes, but mind the following variations:
You may omit the quotes if the alias is a single word that contains only letters, ...
Get SQL: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
