急!~~~简单的语句~~~~把这两句合并成一句,并求出 jksl-cksl 的值
例如:select c.cop_g_no,c.em_g_no,
c.g_name,c.unit,
c.total
from (select a.cop_g_no,a.em_g_no, a.g_name,a.unit,
sum(case a.I_E_MARK when 'I' then a.dec_total else -a.dec_total end) as total
from z_detail a
where a.I_E_MARK like '[IE]'
group by a.cop_g_no,a.em_g_no, a.g_name,a.unit)c order by cop_g_no 但是我现在在上面加了一个条件,不知道如何加
例如:select c.cop_g_no,c.em_g_no,
c.g_name,c.unit,
c.total
from (select a.cop_g_no,a.em_g_no, a.g_name,a.unit,
sum(case a.I_E_MARK when 'I' then a.dec_total else -a.dec_total end) as total
from z_detail a
where a.I_E_MARK like '[IE]'
group by a.cop_g_no,a.em_g_no, a.g_name,a.unit)c order by cop_g_no 但是我现在在上面加了一个条件,不知道如何加
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货