摘要:
select ano,sum(nvl(dmoney,0)) summoneyfrom( select t2.ano,d.dmoney from ( select t1.*,c.cno from( select a.ano,b.bno from t_a a left j... 阅读全文
摘要:
1:update 时做检查使用update mw_contract set payTimes=(case when payTimes>0 then payTimes-1else payTimes end)where contractNo='2015001';2:select时使用select cas... 阅读全文