Search w3schools.com:

SHARE THIS PAGE

SQL Alias

With SQL, an alias name can be given to a table or to a column.

SQL Alias

You can give a table or a column another name by using an alias. This can be a good thing to do if you have very long or complex table names or column names.

An alias name could be anything, but usually it is short.

SQL Alias Syntax for Tables

SELECT column_name(s)
FROM table_name
AS alias_name

SQL Alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name

Demo Database

In this tutorial we will use the well-known Northwind sample database.

Below is a selection from the "Customers" table:

CustomerID CustomerName ContactName Address City PostalCode Country
1

 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitución 2222 México D.F. 05021 Mexico
3 Antonio Moreno Taquería Antonio Moreno Mataderos 2312 México D.F. 05023 Mexico

And a selection from the "Orders" table:

OrderID CustomerID EmployeeID OrderDate ShipperID
10643 1 6 1997-08-25 1
10644 88 3 1997-08-25 2
10645 34 4 1997-08-26 1

Alias Example

Using the "Customers" and "Orders" tables, we give the table aliases of "c" and "o" respectively.

The following SQL statement selects all the orders from the customer "Alfreds Futterkiste":

Example

SELECT o.OrderID, c.CustomerName
FROM Customers AS c,
Orders AS o
WHERE c.CustomerName='Alfreds Futterkiste';

Try it yourself »

The same SELECT statement without aliases:

Example

SELECT Orders.OrderID, Customers.CustomerName
FROM Customers,
Orders
WHERE Customers.CustomerName='Alfreds Futterkiste';

Try it yourself »

As you'll see from the two SELECT statements above; aliases can make queries easier both to write and to read.


Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]