Online Demo

Use the playground below to format SQL examples with different dialects and indentation settings. It also supports live placeholder substitution through the Params panel, a Minified one-line view, and a word-Wrap toggle.

Playground

ExampleBasic filteringJOIN with aggregationCTE and window functionINSERT with multiple rowsUPDATE with CASECorrelated subqueryN1QL nested dataDB2 paginationPL/SQL blockDialectStandard SQLN1QLIBM DB2Oracle PL/SQLIndent2 spaces4 spacesTab

INQueryinput.sql

1

SELECT supplier_name, city FROM suppliers WHERE supplier_id > 500 ORDER BY supplier_name ASC, city DESC;

1 line · 104 charsLive input

OUTFormattedoutput.sql

1 2 3 4 5 6 7 8 9 10

SELECT
  supplier_name,
  city
FROM
  suppliers
WHERE
  supplier_id > 500
ORDER BY
  supplier_name ASC,
  city DESC;

Formatted successfullyStandard SQL · Runs locally