select a.no,a.cou,b.je_2 from
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060701') b
on a.no=b.no
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060701') b
on a.no=b.no
解决方案 »
- 求高手帮忙,关于oracle数据库的配置,急!
- 经常出现Io 异常: The Network Adapter could not establish the connection
- 如何让oracle在事物提交的时候才验证外键约束?
- 大家帮忙 -oracle安装!
- oracle函数的使用问题
- 求一个sql 语句
- 请问这个功能如何在oracle中实现.解决后马上给分
- 在线等待,急!!在数据表test中有数据,但是我又加了一个clob字段后,用select * from test就不能显示出数据来了呢。我该如何显示啊。
- 关于建立java存储过程的错误。
- oracleorahome81agent和oracleservice不能启动怎么解决啊!
- 一個問題,處理的方向都搞不清楚,HELP!!!
- 刚装好的oracle , 连不起,急。。。
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060301') b
on a.no=b.no
FROM(
select no,(je_1),max(rq||je_2) over(PARTITION by NO ) je_2
from table_1
) GROUP BY NO,substr(je_2,7)
from table_1
group by no
FROM (SELECT no, SUM (je_1) je
FROM table_1
GROUP BY no) a LEFT OUTER JOIN (SELECT no, SUM (je_2) je
FROM table_1
WHERE rq = '20060301'
GROUP BY no) b ON (a.no = b.no)
;