KnowledgeBoat Logo

Informatics Practices

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

SQL Joins & Grouping

3 Likes

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.

Answered By

2 Likes


Related Questions