By using SQL, you can specify aliases (alias) for column names and table names.
SQL alias syntax for SQL alias table
SELECT column_name (s) from Table_nameas Alias_name
SQL Alias syntax for columns
SELECT column_name as Alias_namefrom table_name
Alias instance: Using Table name aliases
Let's say we have two tables: "Persons" and "Product_orders", respectively. We assign them the alias "P" and "Po", respectively.
Now we want to list all orders for "John Adams".
We can use the following SELECT statement:
AS p
AS po
WHERE p.lastname= ' Adams ' and p.firstname= ' John '
SELECT statements that do not use aliases:
SELECT Product_orders.orderid, Persons.lastname, Persons.firstnamefrom Persons, Product_orderswhere Persons.LastName = ' Adams ' and persons.firstname= ' John '
As you can see from the two SELECT statements above, aliases make the query program easier to read and write.
Alias instance: Use a Column name alias table Persons:
Id |
LastName |
FirstName |
Address |
| City
1 |
Adams |
John |
Oxford Street |
London |
2 |
Bush |
George |
Fifth Avenue |
New York |
3 |
Carter |
Thomas |
Changan Street |
Beijing |
Sql:
AS Family
AS Name
From Persons
Results:
Family |
Name |
Adams |
John |
Bush |
George |
Carter |
Thomas |
From for notes (Wiz)
By using SQL, you can specify aliases for column names and table names (alias)