Select: Aliases

Aliases — Are used to give a table or a column in a table a temporary name. This name is often used to make the column or table names more readable or to simplify queries, especially when dealing with complex queries involving multiple tables and columns.

Column Aliases — Is used to rename a column in the result set. This can be particularly useful for improving the readability of the output.

SELECT first_name || ' ' || last_name AS full_name, salary
FROM employees;

SELECT column_name AS alias_name
FROM table_name;

Table Aliases — Is used to rename a table within a query. This can make queries easier to write and read, especially when dealing with self-joins or complex queries involving multiple tables.

SELECT o.order_id, c.customer_name
FROM orders AS o
JOIN customers AS c ON o.customer_id = c.customer_id;

SELECT column_name(s)
FROM table_name AS alias_name;