SQL Cheat Sheet/Select specific columns

Return only the columns you need.

Section: SELECT Basics

Select specific columns

sql
sql
SELECT id, email, created_at
FROM users;
Explanation

Selecting fewer columns often improves readability and can reduce I/O.

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 distinct values
Remove duplicate rows for the selected expression set.
OpenIn sheetsqlsame section
Use column aliases
Rename output columns in query results.
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.