SQL Query Builder

Build a SELECT query with a join, filter, grouping, aggregation, and sorting.

Make it work with your data.

SQL dialect

Source table

Select columns (one per line; blank for *)

GROUP BY columns (one per line)

Aggregate

Aggregate column

Join another table

Join table (optional)

Join type

Left column (table.column)

Right column (table.column)

Add a filter

Filter column (optional)

Operator

Filter value

Value type

ORDER BY column (optional)

Direction

Maximum rows

HOW TO USE IT

SQL Query Builder

Enter table and column names, choose the operations, and generate SQL for your database dialect. Review the query before running it.

What to know

This builder accepts column names, not raw expressions. Use one name per line and qualify ambiguous joined columns with their table name. It supports one join, one filter, and one aggregate. Columns selected alongside an aggregate must appear in GROUP BY. The tool generates SQL; it does not connect to your database.

← Explore all tools