| 2. 11. 1. As |
|
|
Defining a new structural element (table or column) by aliasing an existing value. |
A common use for this is to create a shorthand reference to elements with long names to make the SQL statements shorter. |
|
SELECT <columns>
FROM <existing_table_name>
AS <new_table_name>
|
|
is simply a reference that exists for the duration of the SQL statement. |
|
SELECT t1.first_name
FROM employee
AS t1;
|
|