SQL 方言

PostgreSQL

关键字大小写

大写关键字

缩进宽度

缩进风格

标准缩进

缩进方式

使用 Tab

待格式化 SQL

select u.id,u.name,count(o.id) as order_count from users u left join orders o on o.user_id = u.id where u.status = 'active' group by u.id,u.name order by order_count desc;

示例 清空

格式化结果

SELECT u.id, u.name, count(o.id) AS order_count FROM users u LEFT JOIN orders o ON o.user_id = u.id WHERE u.status = 'active' GROUP BY u.id, u.name ORDER BY order_count DESC;

复制结果