often.cloud
source
Theme
← all tools
SQL formatter
Formatting
Pretty-print SQL for MySQL, Postgres, SQLite, BigQuery, Snowflake, and more.
SQL
select u.id, u.name, count(o.id) as orders from users u left join orders o on o.user_id = u.id where u.active = 1 group by u.id, u.name having count(o.id) > 0 order by orders desc limit 10;
Dialect
sql
mysql
postgresql
sqlite
mariadb
bigquery
snowflake
redshift
Indent
2
4
8
UPPERCASE keywords
Formatted
Copy
SELECT u.id, u.name, count(o.id) AS orders FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE u.active = 1 GROUP BY u.id, u.name HAVING count(o.id) > 0 ORDER BY orders DESC LIMIT 10;