- SQL Basics
- SQL Home
- SQL Syntax
- SQL RDBMS
- SQL Databases
- SQL Data Types
- SQL Operators
- SQL Expressions
- SQL Database
- SQL Create Database
- SQL Select Database
- SQL Drop Database
- SQL Table
- SQL Create Table
- SQL Drop Table
- SQL Keywords
- SQL Insert Into
- SQL Select
- SQL Where
- SQL And & Or
- SQL Update
- SQL Delete
- SQL Like
- SQL Select Top
- SQL Group By
- SQL Order By
- SQL Distinct
- SQL In
- SQL Between
- SQL Joins
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Constraints
- SQL Constraints
- SQL Unique
- SQL Not Null
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Advance
- SQL Aliases
- SQL Union
- SQL Auto Increment
- SQL Views
- SQL Dates
- SQL Transactions
- SQL Injection
- SQL Test
- SQL Online Test
- Give Online Test
- All Test List
SQL Aliases
SQL aliases are used to rename the table or the column heading temporarily. Here is the general form of the alias for the columns:
SELECT column_name AS alias_name FROM table_name;
Now, here is the general form of the alias for the tables:
SELECT column_name(s) FROM table_name AS alias_name;
SQL Alias Example
Here is an example of alias in SQL. Consider, we have the following SQL table:

The following SQL statement specifies the two aliases, one for the column Name and other for the column Address.
It requires double quotation marks or square brackets if the column name contains spaces.
SELECT Name AS FullName, Address AS [City] FROM Customers;
After querying the above SQL statements, you will get the following output:

« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋