Developerpublic tool
Code formatter — SQL
Format and minify SQL queries. Major keywords land on their own line.
- Language
- SQL
- Mode
- format
- Indent
- 2
- Local
- 100% browser
Input
SQL query
Output
Formatted with 2-space indent
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.created_at>=now()-interval '30 days'
GROUP BY u.id,u.name
HAVING count(o.id)>0
ORDER BY orders desc
LIMIT 50;