单个连接条件应该与连接在同一行

SQL 代码规范 /

-- Good
select
    users.email,
    sum(charges.amount) as total_revenue
from users
inner join charges on users.id = charges.user_id
group by email

-- Bad
select
    users.email,
    sum(charges.amount) as total_revenue
from users
inner join charges
on users.id = charges.user_id
group by email

当你有多个连接条件时，将每一个条件放在它们自己的缩进行上：

-- Good
select
    users.email,
    sum(charges.amount) as total_revenue
from users
inner join charges on 
    users.id = charges.user_id and
    refunded = false
group by email

本文章首发在 LearnKu.com 网站上。

开根方的茄子

课程读者 369 声望

带娃 @ 蹲家里

教练，我想写代码

讨论数量: 0

发起讨论只看当前版本

暂无话题~