SQL Formatter

Format and standardize SQL across many dialects, including DB2 for z/OS.

OPERATIONAL

DialectKeywordsIdentifiersFunctionsTypesIndentWhitespaceMax widthAlignAND/OROperatorsSemicolonGap

SQL input

1 line · 126 chars

Formatted

12 lines · 150 chars

SELECT
  id,
  name,
  created_at
FROM
  users u
  JOIN orders o ON o.user_id = u.id
WHERE
  u.active = 1
  AND o.total > 100
ORDER BY
  o.total DESC;