select * from ht_htgk tselect s.oid,s.htmc,
(select sum (z.jhje) from jh_ndzjjh z where z.ht_htgkoid=s.oid and z.nf like '200%')as yfje,(select sum (t.sqzf)as s1 from ht_htsq t where t.ht_htgkoid=s.oid) z1,
(select sum (t.jdkhk)as s2 from ht_htsq t where t.ht_htgkoid=s.oid) z2 ,
(select sum (t.zlkhk)as s3 from ht_htsq t where t.ht_htgkoid=s.oid) z3 ,
(select sum (t.aqwmkhk)as s4 from ht_htsq t where t.ht_htgkoid=s.oid) z4from ht_htgk s
我要同时得到Z1,z2,z3,z4的和怎么办.
(select sum (z.jhje) from jh_ndzjjh z where z.ht_htgkoid=s.oid and z.nf like '200%')as yfje,(select sum (t.sqzf)as s1 from ht_htsq t where t.ht_htgkoid=s.oid) z1,
(select sum (t.jdkhk)as s2 from ht_htsq t where t.ht_htgkoid=s.oid) z2 ,
(select sum (t.zlkhk)as s3 from ht_htsq t where t.ht_htgkoid=s.oid) z3 ,
(select sum (t.aqwmkhk)as s4 from ht_htsq t where t.ht_htgkoid=s.oid) z4from ht_htgk s
我要同时得到Z1,z2,z3,z4的和怎么办.
解决方案 »
- 怎么通过Oracle的DBLink同步Informix中的数据
- Oracle 转换SQL(start with)
- oracle数据ddl问题请教??
- 日期转换格式问题:怎样将日期格式转换成"2005年03月01日"!谢谢了.
- 请问怎样写oracle的sql语句,使得只取select结果的前50行?
- 请问怎样设置oracle的缓冲区大小
- 如果我刚刚delete了一张表,想把数据找回来,有没有办法呢?
- 小小问题,大虾们帮帮忙:数据库链接名重复
- 怎么写sql语句可以把数据库中一个字段中相同的只显示一条出来,列出所有不同的记录?
- oracle数据库存储过程与函数
- 存储过程几个简单问题,100分求!
- linux下执行oracle的dbstart,提示Can't find init file for Database "guandadb".
不过没看明白你要干吗
我用了z1+z2+z3+z4这个也不行的
(select sum (z.jhje) from jh_ydzjjh z where z.ht_htgkoid=s.oid and z.nf like '2004'and z.yf like '01')as yfje,
(select sum (t.sqzf) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.12')as ssqzfje,
(select sum (t.jdkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.12')as jdkhk ,
(select sum (t.zlkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.12')as zlkhk ,
(select sum (t.aqwmkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.12')as aqwmkhk
from ht_htgk s就是这个请帮忙看看
from ht_htsq t,ht_htgk s,jh_ydzjjh z
where t.ht_htgkoid=s.oid
and z.ht_htgkoid=s.oid
and z.nf like '2004'and z.yf like '01'
and to_char(t.zfq,'yyyy.mm') = '2005.12'
group by s.oid,s.htmc
select s.oid,s.htmc,
(select sum (z.jhje) from jh_ydzjjh z where z.ht_htgkoid=s.oid and z.nf like '2005'and z.yf like '08')as yfje,
(select sum(t.sqzf+t.jdkhk+t.zlkhk+t.aqwmkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as zfje
from ht_htgk s
不过
t.sqzf+t.jdkhk+t.zlkhk+t.aqwmkhk 这几个字段里面为空的话就不行了
(select sum (z.jhje) from jh_ydzjjh z where z.ht_htgkoid=s.oid and z.nf like '2005'and z.yf like '08')as yfje,
(select sum (t.sqzf) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as sqzf,
(select sum (t.jdkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as jdkhk ,
(select sum (t.zlkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as zlkhk ,
(select sum (t.aqwmkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as aqwmkhk,
(select sum(t.sqzf+t.jdkhk+t.zlkhk+t.aqwmkhk) from ht_htsq t where t.ht_htgkoid=s.oid and to_char(t.zfq,'yyyy.mm') like '2005.08')as zfje
from ht_htgk s
当最后一个字段为空时不显示这一行怎么写呀
各位大狭帮帮