SQL - TABLE ALIAS
An Alias is a name given to any table or column temporarily. This can be done for a query or stored procedure. The renaming is a temporary change and the actual table name does not change in the database.
SYNTAX: Table Alias
SYNTAX: Column Alias
Where,
-
Alias_name: keyword used to give a temporary name to a table/column
EXAMPLE
Let us consider a demo database with table name Persons & Salaries
Figure 31.1.SELECT * FROM PERSONS;
Figure 31.2. SELECT * FROM SALARY;
TABLE ALIAS:
Figure 31.3. TABLE ALIAS;
COLUMN ALIAS:
Figure 31.4. COLUMN ALIAS
PRACTICE YOURSELF
Want More SQL Deep Dives