22,300
社区成员




select 1 as a,case 2 when 2 then 3 else 4 end as b,1*b as c
;with temp as(select 1 as a,case 2 when 2 then 3 else 4 end as b)
select temp.*,temp.b * 1 as c from temp
select 1 as a,case 2 when 2 then 3 else 4 end as b,1*(case 2 when 2 then 3 else 4 end) as c
select a,1*b as c from
(
select 1 as a,case 2 when 2 then 3 else 4 end as b from tab
) t