aliases in sql

By Prof. Fazal Rehman Shamil
Last modified on May 19th, 2021

The aliases in SQL can be used to give a  temporary name to a table, or a column in a table.

Why we use Aliases in SQL?
Aliases are used to make temporary names.
Aliases are used to make column names more readable.
Aliases exist only when we run the query. It does not change the table structure.

Syntax of Alias Column 
SELECT columnName AS aliasName
FROM table_name;

Syntax of Alias Table
SELECT columnNames
FROM tableName AS aliasName;

Example of aliases in SQL

SELECT name AS n, fee AS f
FROM students;

aliases in sql

Let’s see one another example in which we have created two aliases.
one for the name column and one for the fee column.
if the alias name contains spaces, then we need to use the double quotation marks or square brackets in our query.

SELECT name AS “n b”, fee AS f
FROM students;

Exercise: Download the Database of aliases in sql and practice it on your XAMPP phpMyAdmin.


Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.