SQL ALIAS

A table can be temporarily renamed to another name dynamically using ALIAS command

Syntax:

SELECT column1, column2..
FROM table_name AS alias_name
WHERE [condition];

Example:
Suppose we have this customers table
cust_idcust_nameaddresscitypostal_codecountry
1Maria AndersObere Str. 57Berlin12209Germany
2Fran WilsonC/ Araquil, 67Madrid28023Spain
3Dominique Perrier25, rue LauristonParis75016France
4Martin BlankVia Monte Bianco 34Turin10100Italy
5Thomas Hardy89 Chiaroscuro Rd.Portland97219USA
6Christina AguileraGran Va, 1Madrid28001Spain
7Hanna MoosForsterstr. 57Mannheim68306Germany

SELECT cust_name, city, country FROM customers AS people where cust_id <6

it will create an alias table name people with those columns.

cust_namecitycountry
Maria AndersBerlinGermany
Fran WilsonMadridSpain
Dominique PerrierParisFrance
Martin BlankTurinItaly
Thomas HardyPortlandUSA

Learn more : SQL Tutorial , SQL Interview Questions