Question

求个SQL语句 B列值为0则设置为1，值为1则不变。 C列等于A/C

A B C
1 1 NULL
0 1 NULL
1 0 NULL

Answer 1

这样写就行了
select A,(case when B = 0 then 1 else B end) as B ,A/C as C from table

追问

高手，再问一个哦。帮帮忙哈。
B为0时。C等于7，B不为0时，C等于A/B。

追答

select A,(case when B = 0 then 1 else B end) as B ,(case when b = 0 then 7 else A/B end) as C from table

Answer 2

select (case b when 0 then 1 else 1 end) b ,(a/c) c from table