2010年
-
编辑 删除
oracle case
select substr(msgtime,1,6),b.real_name,--decode(a.respon_type_text ,like 'LYGWL','','','','')case when a.respon_type_text like '%运抵%' then '运抵提单数'when a.respon_type_text like '%理货%' then '理...
-
编辑 删除
oracle sign
select user_name,real_name,amountdesc,max(decode(TO_CHAR(to_date(a.sendtime,'YYYYMMDD'),'iw'),decode(sign(to_char(sysdate,'iw')-4),1,to_char(sysdate,'iw')-4,to_char(sysdate,'iw')-4+53),amount,0)) as ...
