← All tools

SQL SELECT Builder

Build a SELECT statement with chosen columns, typed WHERE conditions, sorting and a row limit.

sql-select-builderLOCAL WORKSPACE

Enabling local controls…

Selected columns
WHERE conditions
Condition 1

Preview: first 32,000 characters. Copy, download and expanded text retain all content. Select complete text if copying fails.

SELECT "id", "name"
FROM "members"
WHERE "active" = TRUE
ORDER BY "id" ASC
LIMIT 25;
Expand complete selectable text
SELECT "id", "name"
FROM "members"
WHERE "active" = TRUE
ORDER BY "id" ASC
LIMIT 25;

How to use this tool

Choose a dialect and enter table and column names as stored in your database. Leave the output column list empty to select every column. Conditions all use the same AND or OR connector. Review, copy or download the SQL locally.

When not to use it

Enter one identifier per field. For a qualified table, use the separate schema or database field. This builder supports a single table and one sort column. Values are treated as literal text, decimals or booleans. Use bound parameters when writing application queries.