Select specific columns
Read only the columns needed from a table.
SELECT <columns> FROM <table>;SQL Commands
Query, join, aggregate, update, and inspect relational data with clear dialect labels.
Example commands
Join matching rows
Return rows whose join key exists in both tables.
SELECT * FROM <left_table> AS l INNER JOIN <right_table> AS r ON l.<key> = r.<key>;Count rows by group
Count how many rows belong to each distinct value.
SELECT <column>, COUNT(*) AS count FROM <table> GROUP BY <column>;Preview rows before updating
Review the exact rows a later UPDATE statement would change.
SELECT * FROM <table> WHERE <condition>;Start a transaction
Start a transaction so related changes can be committed or rolled back together.
BEGIN;Inspect a query plan
Show how the database plans to execute a query without changing data.
EXPLAIN <query>;Search and copy controls need JavaScript. The command examples above remain readable without it.