SQL Formatter

Beautify, format, and indent complex SQL queries.

Dialect:Keywords:Indent:

SQL Query

SELECT u.id, u.name, u.email, COUNT(o.id) AS orders_count FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.active = 1 GROUP BY u.id, u.name ORDER BY orders_count DESC LIMIT 20;

Formatted SQL

SELECT
  u.id,
  u.name,
  u.email,
  COUNT(o.id) AS orders_count
FROM
  users u
  LEFT JOIN orders o ON u.id = o.user_id
WHERE
  u.active = 1
GROUP BY
  u.id,
  u.name
ORDER BY
  orders_count DESC
LIMIT
  20;

⌁

Your input stays here. This tool processes data in your browser and does not send the input to Jobiqon's backend.