Sep 9, 2019 in Spark Sql

SQL Aliases

1 Answer

0 votes
Sep 9, 2019

SQL Aliases

SQL aliases are used to give a table, or a column in a table, a temporary name.

Aliases are often used to make column names more readable.

An alias only exists for the duration of the query.

Alias Column Syntax

SELECT column_name AS alias_name
FROM table_name;

Alias Table Syntax

SELECT column_name(s)
FROM table_name AS alias_name;
Click here to read more about Loan/Mortgage
Click here to read more about Insurance