SQL SELECT Query Builder
Columns
— what to select
Aggregate mode: SELECT is built from GROUP BY columns + aggregates below. Plain column picks are ignored.
Filters
— WHERE
AND
OR
+ Add filter
Group by
— buckets rows
Aggregates
— per group
+ Add aggregate
Order by
ASC
DESC
Limit
Generated SQL
Result
Prompt
Copy Prompt