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
1	Tom	34	Paris	5300
2	Jhony	51	London	400
3	Ram	64	Delhi	20000.7
4	Simon	23	Portland	32.65

Online Execute/Compile
select name,id,city from customers as customer_info ;

: Scanftree

sql

sql-alias

SQL

DQL :Data Query

DML :Data Manipulation

DDL :Data Definition

TCL :Transaction Control

DCL :Data Control

SQL others

SQL Function

SQL Alias

SYNTAX :

Table Name 'customers'

id

name

age

city

bill

Aptitude / Reasoning / Interview

Physical education & sports