求sql语句,分数不多,望各位大虾帮忙 这也写sql,有点太那个了吧,本来在程序里控制是非常简单的。楼主再考虑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 第一题:select sc2 - lag(sc2,1,0) over(order by sc2) result from (select c1,sum(c2) over(order by rownum) sc2, lead(c1,1,0) over(order by rownum) lc1 from b)where c1 <> lc1SQL> select * from b; C1 C2---------- ---------- 20 2 20 2 30 2 20 3 20 2 20 3 30 37 rows selectedSQL> 6 / RESULT---------- 4 2 8 3第二题:select decode(sc2 + lag(sc2,1,-1) over(order by sc1),0,sc1-75,-2,0,c1) result from (select c1,sum(c1) over(order by rownum) sc1, sign(sum(c1) over(order by rownum)-75) sc2 from b)SQL> 6 / RESULT---------- 0 0 0 15 20 20 30 Oracle 11.2.0.1.0 expdp 报错 oracel 字符集更换 win 7装oracle出错!!! 我在导入一个DMP文件后出现一些错误 帮忙介绍一下用oci操作8i和9i时的区别 如何学习Oracle? Oracle中如何修改用户名?急,在线等。。。 oracle10中如何导入数据库 Oracle8i技术问题 关于oracle数据库,sql里面如何处理'单引号的插入 这样的sql语句怎么写? 怎样在oracle中存取图片?
select sc2 - lag(sc2,1,0) over(order by sc2) result from
(select c1,sum(c2) over(order by rownum) sc2,
lead(c1,1,0) over(order by rownum) lc1
from b)
where c1 <> lc1SQL> select * from b; C1 C2
---------- ----------
20 2
20 2
30 2
20 3
20 2
20 3
30 37 rows selectedSQL>
6 / RESULT
----------
4
2
8
3
第二题:
select decode(sc2 + lag(sc2,1,-1) over(order by sc1),0,sc1-75,-2,0,c1) result
from
(select c1,sum(c1) over(order by rownum) sc1,
sign(sum(c1) over(order by rownum)-75) sc2
from b)SQL>
6 / RESULT
----------
0
0
0
15
20
20
30