a1 = a1+b1+b2+c1+c2 = 5+3+0+0+3 = 11
解决方案 »
- 数据库连接的问题
- red hat5.2下安装oracle11g
- 求教——用SQL 或 触发器实现在数据表一列中统一追加相同的内容!!!
- 求助oracle中将含有运算符和括号的字符串转换成公式并且运算结果
- Win2008+Oracle11g双机热备下Oracle如何安装
- 怎样取得本月的第一天和本月最后一天?--急急
- 行转列问题!
- 向老大们请教一个从数据库中返回多行结果级的问题,难点使用的游标存在于动态SQL语句
- 生产环境上Oracle 11G alert log里面总是报 TNS-12535: TNS:operation timed out的信息
- oracle数据库,查询语句中有case函数,在java里用SQLQuery的query.list查询之后,查到的值被缩短了
- 求助一个批处理文件?
- 在PL/SQL中,怎样判断一次查询的结果是否为空?
2 select ts1.*, nvl(DATA1, 0) DATA1, nvl(DATA2, 0) DATA2 from ts1, data1 where ts1.NODEID=data1.N
ODEID(+))
3 start with PARENTID=0
4 connect by prior NODEID=PARENTID;SUM(DATA1) SUM(DATA2)
---------- ----------
11 13
zhang@zhang>select sum(data1), sum(data2) from (
2 select ts1.*, nvl(DATA1, 0) DATA1, nvl(DATA2, 0) DATA2 from ts1, data1 where ts1.NODEID=data1.N
ODEID(+))
3 start with PARENTID=0 and NODENAME='a2'
4 connect by prior NODEID=PARENTID;SUM(DATA1) SUM(DATA2)
---------- ----------
0 0zhang@zhang>select sum(data1), sum(data2) from (
2 select ts1.*, nvl(DATA1, 0) DATA1, nvl(DATA2, 0) DATA2 from ts1, data1 where ts1.NODEID=data1.N
ODEID(+))
3 start with PARENTID=0 and NODENAME='a1'
4 connect by prior NODEID=PARENTID;SUM(DATA1) SUM(DATA2)
---------- ----------
11 13
2 select ts1.*, nvl(DATA1, 0) DATA1, nvl(DATA2, 0) DATA2 from ts1, data1 where ts1.NODEID=data1.N
ODEID(+))
3 start with PARENTID=0 and NODENAME='a1'
4 connect by prior NODEID=PARENTID
5 union
6 select 1 nodeid, 'a2' nodename, sum(data1) data1, sum(data2) data2 from (
7 select ts1.*, nvl(DATA1, 0) DATA1, nvl(DATA2, 0) DATA2 from ts1, data1 where ts1.NODEID=data1.N
ODEID(+))
8 start with PARENTID=0 and NODENAME='a2'
9 connect by prior NODEID=PARENTID; NODEID NO DATA1 DATA2
---------- -- ---------- ----------
1 a1 11 13
1 a2 0 0