select c.* from (select a.jzdbm as jzdbm,a.jzzm as jzzm,a.rzrq as rzrq,a.ywzy as ywzy,a.ckfs as ckfs,b.kjdm as kjdm,(nvl(sum(a.jf),0)+nvl(sum(a.df),0)) as sjje,b.kjdm from table1 a,table2 b where a.jzdbm=b.dm and a.rzrq<='20110510' and (a.hdbz='' or a.hdbz is null) group by a.jzdbm,a.jzzm,a.rzrq,a.ywzy,a.ckfs,b.kjdm) c order by c.kjdm
想实现按table2表的kjdm字段排序。请各位帮忙看看,谢谢
想实现按table2表的kjdm字段排序。请各位帮忙看看,谢谢
解决方案 »
- 如何识别网络包是否为oracle数据包
- 关于oracle的执行计划的输出的问题,请高手执教,好像很难(星期六还上班)
- 在Dephi里执行insert into table1(col1,col2) select col1,col2 from table2 之类的语句时报错
- 为什么不能配置 OMS??
- Windows 应用程序能用 Ole DB Provider 连接 Oracle 吗?
- oracle有存储过程吗?
- sys.aud$中的数据删不掉, 怎么办? 急!
- 【提问】PL/SQL里 有10条INSERT语句,想要一次执行,该怎么写? 谢谢。
- 在oracle 中实现取前几条记录的 SQL语句怎么写
- 请问,哪有Oracle9i下载
- 同一用户,同一条sql语句,查询出不同结果?
- oracle 时间按小时 分组统计
a.jzzm as jzzm,
a.rzrq as rzrq,
a.ywzy as ywzy,
a.ckfs as ckfs,
b.kjdm as kjdm,
(nvl(sum(a.jf),0)+nvl(sum(a.df),0)) as sjje
from table1 a,table2 b
where a.jzdbm=b.dm and a.rzrq<='20110510' and a.hdbz is null
group by jzdbm,jzzm,rzrq,ywzy,ckfs,kjdm
order by kjdm
a.jzdbm as jzdbm,
a.jzzm as jzzm,
a.rzrq as rzrq,
a.ywzy as ywzy,
a.ckfs as ckfs,
b.kjdm as kjdm,
(nvl(sum(a.jf),0)+nvl(sum(a.df),0)) as sjje
from table1 a,table2 b
where a.jzdbm=b.dm and a.rzrq<='20110510' and a.hdbz is null
group by a.jzdbm,a.jzzm,a.rzrq,a.ywzy,a.ckfs,b.kjdm
order by kjdm