预热 case when 用法:
(一):select case when 1=1 then 1 end from dual;
结果:
(二):
表结构:
select (case when xm='gao' then '姓高的销售额' when xm= 'zhu' then '姓朱的销售额' end ), sal from table3;<
预热 case when 用法:
(一):select case when 1=1 then 1 end from dual;
结果:
(二):
表结构:
select (case when xm='gao' then '姓高的销售额' when xm= 'zhu' then '姓朱的销售额' end ), sal from table3;<