SQL – Aliases
Table Of Contents:
- What Is SQL Aliases?
- Syntax Of SQL Aliases.
- Examples Of SQL Aliases.
(1) What Is SQL Aliases?
SQL aliases are used to give a table, or a column in a table, a temporary name.
Aliases are often used to make column names more readable.
An alias only exists for the duration of that query.
An alias is created with the
AS
keyword.
(2) Syntax Of SQL Aliases.
Syntax: Alias Column Syntax
SELECT column_name AS alias_name
FROM table_name;
Syntax: Alias Table Syntax
SELECT column_name(s)
FROM table_name AS alias_name;
(3) Examples Of SQL Aliases.
Demo Dataset:
Example-1:
SELECT CustomerID AS ID, CustomerName AS Customer
FROM Customers;
Example-2: Space In Aliase Name
SELECT CustomerName AS Customer, ContactName AS [Contact Person]
FROM Customers;
Example-3: Combine Multiple Columns
SELECT CustomerName, Address + ', ' + PostalCode + ' ' + City + ', ' + Country AS Address
FROM Customers;
Example-4: Combine Multiple Columns In MYSQL
SELECT CustomerName, CONCAT(Address,', ',PostalCode,', ',City,', ',Country) AS Address
FROM Customers;
Example-5: Alias For Table Example
SELECT o.OrderID, o.OrderDate, c.CustomerName
FROM Customers AS c, Orders AS o
WHERE c.CustomerName='Around the Horn' AND c.CustomerID=o.CustomerID;
Example-6: Alias For Table Example
SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName
FROM Customers, Orders
WHERE Customers.CustomerName='Around the Horn' AND Customers.CustomerID=Orders.CustomerID;