返回首页
格式化SQL
压缩SQL
清除内容
SQL输入区
SELECT u.id, u.name, u.email, o.order_date, o.total FROM users u LEFT JOIN orders o ON u.id = o.user_id RIGHT JOIN payments p ON o.id = p.order_id INNER JOIN customers c ON u.customer_id = c.id FULL OUTER JOIN invoices i ON c.id = i.customer_id WHERE u.status = ? AND o.total > #{minTotal} AND o.order_date BETWEEN ${startDate} AND #{endDate} GROUP BY u.id HAVING COUNT(o.id) > 3 ORDER BY o.total DESC;
格式化结果
复制
已格式化