select k.quarter,k.wxpect1,k.expect2,k.fact1,k.fact2 from 表 k where exists(select sum(d.wxpect1),sum(d.expect2),sum(d.fact1),sum(d.fact2) from 表 d where d.quarter in(k.quarter)
解决方案 »
- 数据格式化问题
- 统计子部门人数的问题
- oracle 数据库,监听停了以后,直接就shutdown immediate,然后 数据库的服务器就再连不上了
- 请教 存储过程中,如何返回一个游标类型??
- oracle中如何取时间最晚的那笔数据?
- 求教!!!怎么在触发器里面判断2个表中的数据大小~~~
- win2000 pro安装oracle9i后,创建数据库出错
- 在線等!sql裡怎麼把單引號變成雙引號?
- v$datafile不更新?
- orale数据库设计
- 好急的问题啊,各位高手赶快来拉我一把,关于修改控制文件的问题?在线!!
- 请问大家我的这个函数在oracle 8i中为什么报错,错在哪里,我对Oracle 8.i实在不了解?
where b.quarter<=a.quarter
group by a.quarter;
sum(EXPECT1) over (partition by substr(QUARTER,1,4) order by QUARTER)
as EXPECT1_sum
from table1;
sum(EXPECT1) over (order by QUARTER)
as EXPECT1_sum
from table1;
select QUARTER,EXPECT1,sum(EXPECT1) over(partition by substr(QUARTER,5,1) order by substr(QUARTER,1,4)) from tab1 order by QUARTER
以年来分组:
select QUARTER,EXPECT1,sum(EXPECT1) over(partition by QUARTER order by QUARTER) from tab1 order by QUARTER