SQL SELECT AS
SQL AS is used to assign temporarily a new name to a table column.
It makes easy presentation of query results and allows the developer to label results more accurately without permanently renaming table columns.
Let's see the example of select as:
Let us take a table named orders, it contains:
After applying this SQL AS example syntax
Result will be shown as this table:
Note: SQL AS is same as SQL ALIAS.