SQL Syntax Lab
SELECT basicsBeginner
SELECT basic columns
Pull publisher impression totals from a reporting table.
Use SELECT to choose specific columns from a table.
Example
SELECT publisher_id, impressions
FROM daily_ad_stats;Notes
- SELECT chooses the columns you want to return.
- FROM tells SQL which table to query.
Related concepts
SELECTFROM
Practice editor
Type SQL here. Nothing is executed.
SQL highlightingSaved locally
Loading editor...
Drafts are stored in this browser for this example only. Syntax checking is optional and runs locally.