SQL Advanced

SQL Alias

With SQL, aliases can be used for column names and table names.

Column Name Alias

The syntax is:

Table Name Alias

The syntax is:

Example: Using a Column Alias

This table (Persons):

And this SQL:

Returns this result:

Example: Using a Table Alias

This table (Persons):

And this SQL:

Returns this result:

Table Employees: