BlogJava-licheng700-最新评论http://www.blogjava.net/licheng700/CommentsRSS.aspxzh-cnWed, 28 Sep 2005 07:00:00 GMTWed, 28 Sep 2005 07:00:00 GMTcnblogsre: Session详解 http://www.blogjava.net/licheng700/archive/2006/11/10/13494.html#80313Peng GaoPeng GaoFri, 10 Nov 2006 01:56:00 GMThttp://www.blogjava.net/licheng700/archive/2006/11/10/13494.html#80313

Peng Gao 2006-11-10 09:56 发表评论
]]>re: Session详解 http://www.blogjava.net/licheng700/archive/2006/11/03/13494.html#78852ssFri, 03 Nov 2006 01:34:00 GMThttp://www.blogjava.net/licheng700/archive/2006/11/03/13494.html#78852

s 2006-11-03 09:34 发表评论
]]>re: Session详解 http://www.blogjava.net/licheng700/archive/2006/11/02/13494.html#78721yyThu, 02 Nov 2006 08:14:00 GMThttp://www.blogjava.net/licheng700/archive/2006/11/02/13494.html#78721

y 2006-11-02 16:14 发表评论
]]>re: 一段SQLhttp://www.blogjava.net/licheng700/archive/2005/08/25/11079.html#11096小海船小海船Thu, 25 Aug 2005 09:02:00 GMThttp://www.blogjava.net/licheng700/archive/2005/08/25/11079.html#11096sum(decode(n_direction,1,n_amount, 0)) amountOfDebit,
sum(decode(n_direction,2,n_amount, 0)) amountOfCredit,
sum(n_amount) amount,
sum(decode(n_direction,1,1, 0)) numOfDebitTrans,
sum(decode(n_direction,2,1, 0)) numOfCreditTrans,
COUNT(n_direction) nums
from
(select a.n_id n_id,a.n_accountid n_accountid ,a.n_currencytype n_currencytype,
a.n_amount n_amount,a.n_direction n_direction,a.dt_modifytime dt_modifytime,
b.s_accountno accountNO,b.s_accountname accountName from
(select n_id ,n_accountid,n_currencytype,n_amount,n_direction,dt_modifytime from bs_accthistransinfo where 1=1
union all
select n_id ,n_accountid,n_currencytype,n_amount,n_direction,dt_modifytime from bs_acctcurtransinfo where 1=1)
a,
(select * from bs_bankaccountinfo where
n_accountstatus= 1
and n_ischeck=1) b where a.n_currencytype=b.n_currencytype and a.n_accountid=b.n_id and
to_char(a.dt_modifytime,'yyyy-mm-dd')>='2005-01-01' and
to_char(a.dt_modifytime,'yyyy-mm-dd')<='2006-01-01'
)c group by n_accountid,accountNO,accountName

小海船 2005-08-25 17:02 发表评论
]]>