SQL Alias

Alias keyword is used for giving a name to a column/table. It is a good practice to give a name to result, it decimates confusion. These names are usually short.


SYNTAX :
SELECT column_name(s)
FROM table_name
AS alias_name ;


Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview