Souus Tools
中文
Sponsor
Sql Formatter
SQL Input
SELECT u.id, u.name, u.email, o.total_amount FROM users u INNER JOIN orders o ON u.id = o.user_id LEFT JOIN addresses a ON u.id = a.user_id WHERE u.created_at >= '2024-01-01' AND o.status IN ('completed', 'shipped') AND a.country = 'US' GROUP BY u.id, u.name, u.email, o.total_amount HAVING o.total_amount > 100 ORDER BY o.total_amount DESC LIMIT 50;
Dialect
Standard SQL
MySQL
PostgreSQL
SQLite
T-SQL
PL/SQL
MariaDB
BigQuery
Indent
2 spaces
4 spaces
Tab
Keyword case
Preserve
UPPERCASE
lowercase
Line between queries
复制
SELECT u.id, u.name, u.email, o.total_amount FROM users u INNER JOIN orders o ON u.id = o.user_id LEFT JOIN addresses a ON u.id = a.user_id WHERE u.created_at >= '2024-01-01' AND o.status IN ('completed', 'shipped') AND a.country = 'US' GROUP BY u.id, u.name, u.email, o.total_amount HAVING o.total_amount > 100 ORDER BY o.total_amount DESC LIMIT 50;