select
case when A>0 then A else null end as A1
,case when A<0 then A else null end as A2
from
表名
实例:
select
info.vehicle_no,info.work_area,ttype."name",tinfo.sim_no,tinfo.terminal_type,--tinfo.terminal_no
case when tinfo.terminal_type = '1' then tinfo.terminal_no else '' end as terminal_no,
case when tinfo.terminal_type = '2' then tinfo.terminal_no else '' end as highTerminalNo
from
t_vehicle_info info
LEFT JOIN t_terminal_ref_vehicle tvref on info.id = tvref.vehicle_id
LEFT JOIN t_terminal_info tinfo on tvref.terminal_id = tinfo.id
LEFT JOIN t_dict_type ttype on ttype.code = info.work_area