select sum(sum) from table where TYPE2=case when TYPE1 WHEN D THEN 2 ELSE 1 END
select sum(sum) from table where TYPE2=case when TYPE1 WHEN 'D' THEN 2 ELSE 1 END
select sum from talbe1 where type2 = (case when type1 = 'D' then 2 else 1 end)
select sum(sum) from table where TYPE2=(case when TYPE1 WHEN 'D' THEN 2 ELSE 1 END)
如果TYPE1为D的话,显示TYPE2为2的SUM 如果TYPE2为C的话,显示TYPE2为1的SUMselect sum(sum) from table where TYPE2=(case when TYPE1 WHEN 'D' THEN 2 ELSE (case when TYPE1 WHEN 'C' THEN 1 END) END)
总是提示“=”附近语法错误
from table
where TYPE2=case when TYPE1 WHEN D THEN 2 ELSE 1 END
from table
where TYPE2=case when TYPE1 WHEN 'D' THEN 2 ELSE 1 END
where type2 = (case when type1 = 'D' then 2 else 1 end)
from table
where TYPE2=(case when TYPE1 WHEN 'D' THEN 2 ELSE 1 END)
如果TYPE2为C的话,显示TYPE2为1的SUMselect sum(sum)
from table
where TYPE2=(case when TYPE1 WHEN 'D' THEN 2 ELSE (case when TYPE1 WHEN 'C' THEN 1 END) END)