Posted on 2006-01-11 14:40
yoyozy 閱讀(215)
評論(0) 編輯 收藏
1.書寫格式 示例代碼：
存儲過程SQL文書寫格式例
select
c.dealerCode,
round(sum(c.submitSubletAmountDLR + c.submitPartsAmountDLR + c.submitLaborAmountDLR) / count(*), 2) as avg,
decode(null, 'x', 'xx', 'CNY')
from (
select
a.dealerCode,
a.submitSubletAmountDLR,
a.submitPartsAmountDLR,
a.submitLaborAmountDLR
from SRV_TWC_F a
where (to_char(a.ORIGSUBMITTIME, 'yyyy/mm/dd') >= 'Date Range(start)'
and to_char(
文章來源:
http://blog.donews.com/yoyozy/archive/2005/11/04/615205.aspx