Aliases: Column Aliases

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;