Online Demo

Use the playground below to format SQL examples with different dialects and indentation settings.

ExampleBasic filteringJOIN with aggregationCTE and window functionN1QL nested dataDB2 paginationPL/SQL blockLanguageSQLN1QLDB2PL/SQLIndent2 spaces4 spacesTab

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

Formatted

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