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

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin