SQL 代码规范对齐 case/when 语句
case 和每一个 when 都需要独占一行，并且 when 比 case 缩进深一行。 then 应该和其对应的 when 在同一行，或者下面一行并有更深一级缩进：
-- Good
select
case
when event_name = 'viewed_homepage' then 'Homepage'
when event_name = 'viewed_editor' then 'Editor'
else 'Other'
end as page_name
from events
-- Good too
select
case
when event_name = 'viewed_homepage'
then 'Homepage'
when event_name = 'viewed_editor'
then 'Editor'
else 'Other'
end as page_name
from events
-- Bad
select
case when event_name = 'viewed_homepage' then 'Homepage'
when event_name = 'viewed_editor' then 'Editor'
else 'Other'
end as page_name
from events
关于 LearnKu
粤公网安备 44030502004330号