CBSE Class 12 Informatics Practices Question 52 of 91

JOINS and SET Operations — Question 3

Back to all questions
3
Question

Question 3

What is a table alias ? What is the purpose of table alias ?

Answer

A table alias is a temporary label given along with table name in the FROM clause.

Table aliases are used to give a temporary name to a table within a SQL query, making it easier to read and reference columns, especially when working with long table names, self-joins, or multiple references to the same table.