select t.MchntID,
m.MchntName,
t.CheckDate,
to_number(t.BeginMoney) BeginMoney,
to_number(t.EndMoney) EndMoney,
to_number(t.InMoney) InMoney,
to_number(t.RtnMoney) RtnMoney,
to_number(t.FixMoney) FixMoney,
to_number(t.TranMoneyCM) TranMoneyCM,
to_number(t.TranCountCM) TranCountCM,
to_number(t.TranMoneyCUN) TranMoneyCUN,
to_number(t.TranCountCUN) TranCountCUN,
to_number(t.TranMoneyCTC) TranMoneyCTC,
to_number(t.TranCountCTC) TranCountCTC,
to_number(t.TranMoneyTotal) TranMoneyTotal,
to_number(t.TranCountTotal) TranCountTotal,
to_number(t.BeginMoney)+to_number(t.InMoney)+to_number(t.RtnMoney)-to_number(t.FixMoney)-to_number(t.EndMoney)-to_number(t.TranMoneyTotal) as hedui
from user_checkinfo t,m_merchant m
where t.mchntid = m.mchntid
and (beginmoney<>'0' or inmoney <> '0' or endmoney<>'0' or rtnmoney<>'0' or fixmoney<>'0' or trancounttotal<>'0')
and t.checkdate='20110623'
order by hedui desc;
m.MchntName,
t.CheckDate,
to_number(t.BeginMoney) BeginMoney,
to_number(t.EndMoney) EndMoney,
to_number(t.InMoney) InMoney,
to_number(t.RtnMoney) RtnMoney,
to_number(t.FixMoney) FixMoney,
to_number(t.TranMoneyCM) TranMoneyCM,
to_number(t.TranCountCM) TranCountCM,
to_number(t.TranMoneyCUN) TranMoneyCUN,
to_number(t.TranCountCUN) TranCountCUN,
to_number(t.TranMoneyCTC) TranMoneyCTC,
to_number(t.TranCountCTC) TranCountCTC,
to_number(t.TranMoneyTotal) TranMoneyTotal,
to_number(t.TranCountTotal) TranCountTotal,
to_number(t.BeginMoney)+to_number(t.InMoney)+to_number(t.RtnMoney)-to_number(t.FixMoney)-to_number(t.EndMoney)-to_number(t.TranMoneyTotal) as hedui
from user_checkinfo t,m_merchant m
where t.mchntid = m.mchntid
and (beginmoney<>'0' or inmoney <> '0' or endmoney<>'0' or rtnmoney<>'0' or fixmoney<>'0' or trancounttotal<>'0')
and t.checkdate='20110623'
order by hedui desc;
解决方案 »
- java对象是引用,为何我传入的stmt对象,没有传回
- text 文本 里面怎如何添加一张图片?
- 我的jsp页面打不开,求救
- 又遇见一个空指针问题,感觉报错的代码不可能有问题啊!大家进来看看!
- ¥¥¥¥¥¥¥ 请教struts FormBean 的问题 ¥¥¥¥¥¥¥¥¥¥
- 怎样调用另一页面的变量?
- 动态Form问题,如何配置验证请给一段好吗?【最好有解释谢谢!!】
- 菜鸟级问题,请教各位beans的存放位置
- 推荐你认为比较好的连接池代码?
- jsp从Access数据库中读数据中文无法显示怎么解决?急!
- AnnotationException 初学者
- 获取<html:checkbox property="is_full">是否选中
select * from (
select t.MchntID,
m.MchntName,
t.CheckDate,
to_number(t.BeginMoney) BeginMoney,
to_number(t.EndMoney) EndMoney,
to_number(t.InMoney) InMoney,
to_number(t.RtnMoney) RtnMoney,
to_number(t.FixMoney) FixMoney,
to_number(t.TranMoneyCM) TranMoneyCM,
to_number(t.TranCountCM) TranCountCM,
to_number(t.TranMoneyCUN) TranMoneyCUN,
to_number(t.TranCountCUN) TranCountCUN,
to_number(t.TranMoneyCTC) TranMoneyCTC,
to_number(t.TranCountCTC) TranCountCTC,
to_number(t.TranMoneyTotal) TranMoneyTotal,
to_number(t.TranCountTotal) TranCountTotal,
to_number(t.BeginMoney)+to_number(t.InMoney)+to_number(t.RtnMoney)-to_number(t.FixMoney)-to_number(t.EndMoney)-to_number(t.TranMoneyTotal) as hedui
from user_checkinfo t,m_merchant m
where t.mchntid = m.mchntid
and (beginmoney<>'0' or inmoney <> '0' or endmoney<>'0' or rtnmoney<>'0' or fixmoney<>'0' or trancounttotal<>'0')
and t.checkdate='20110623'
) as temp
order by temp.hedui desc;