SQL AS – the Alias Statement

SQL AS renames a column or table to a more convenient alias (a correlation name) without changing the original names in the database. This makes writing queries easier when the original table or column names are long or complicated.

SQL AS: Main Tips

• SQL AS is used as a temporary name for the purpose of a particular SQL query.
• Aliases ensure better readability.

SQL AS for Columns

SELECT col_name AS al_name
FROM tbl_name;

The example below describes both CustomerName and ContactName aliases.

When there are spaces between names of the columns, you must use square brackets or quotation marks:

SELECT ID as CustomerID, Name AS Customers
FROM Customers;

Pros

• Easy to use with a learn-by-doing approach
• Offers quality content
• Gamified in-browser coding experience
• The price matches the quality
• Suitable for learners ranging from beginner to advanced

Main Features

• Free certificates of completion
• Focused on data science skills
• Flexible learning timetable

GET 25% OFF

Pros

• Simplistic design (no unnecessary information)
• High-quality courses (even the free ones)
• Variety of features

Main Features

• Nanodegree programs
• Suitable for enterprises
• Paid Certificates of completion

UP TO 70% OFF

Pros

• A wide range of learning programs
• University-level courses
• Easy to navigate
• Verified certificates
• Free learning track available

Main Features

• University-level courses
• Suitable for enterprises
• Verified certificates of completion

FREE COURSES

SQL AS for Tables

SELECT col_name(s)
FROM tbl_name AS al_name;

The example below picks out every order from customer with CustomerID=4. The aliases of the tables are given o and c for the orders and the customers table. This is done to make the SQL code shorter.

SELECT o.ID, c.Name
FROM Customers AS c, Customer_orders AS o
WHERE c.id = 2 AND c.ID = o.customer_id;

And a matching example with no alias:

SELECT Customer_orders.ID, Customers.Name
FROM Customers, Customer_orders
WHERE Customers.id = 2 AND Customers.ID = Customer_orders.customer_id;

Demo Database

In the table below you can see a piece of Customers table:

Customer_Orders

SQL AS: Summary

• Using alias does not change a column or table name in the original database.
• Aliases make complicated or long names easier read.