SQL Cheat Sheet/Use column aliases

Rename output columns in query results.

Section: SELECT Basics

Use column aliases

sql
sql
SELECT first_name AS given_name, last_name AS family_name
FROM users;
Explanation

Aliases are especially useful in reports and computed expressions.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing SELECT Basics
Select all columns
Return all columns from a table.
OpenIn sheetsqlsame section
Select specific columns
Return only the columns you need.
OpenIn sheetsqlsame section
Select distinct values
Remove duplicate rows for the selected expression set.
OpenIn sheetsqlsame section
Select literals and expressions
Project computed values directly in the result set.
OpenIn sheetsqlsame section
Filter with equality
Return rows matching an exact value.
Sort rows
Order query results ascending or descending.