两种条件过滤合并到一个语句select a from tab where num = 0select b from tab where num <> 0合并到一个语句 [解决办法]
select case when num = 0 then a when num <> 0 then b end as Cfrom tab