By using SQL, you can specify aliases for column names and table names (alias)

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 pAS poWHERE 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: City

Id	LastName	FirstName	Address
1	Adams	John	Oxford Street	London
2	Bush	George	Fifth Avenue	New York
3	Carter	Thomas	Changan Street	Beijing

Sql:

AS FamilyAS NameFrom 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)