SQL SELECT

What & Why

The SELECT statement is used to choose which columns a query returns. SELECT is the output contract of every query. It tells the database which fields should be visible to the analyst, dashboard, export, or stakeholder.

See how it works

A growth analyst wants only the columns needed to review recent users, not every field in the table.

SELECT
  id,
  country,
  channel,
  created_at
FROM growth.users
LIMIT 10;

Syntax pattern

See explanation

SELECT column_1, column_2
FROM schema.table_name;

List explicit columns instead of SELECT * when the query feeds a report.
Use commas between selected expressions.
Aliases with AS make output column names easier to read.

Now You Try

Practice this concept hands-on

Run SQL against real datasets right here in the browser and get instant AI feedback. Join the waitlist to get access.

Join the waitlist