ORACLE 统计正负个数sql
来源:互联网 发布:淘宝双12活动力度 编辑:程序博客网 时间:2024/04/20 10:59
select ss.*,
sum(ss.aa) over (partition by ss.zsid order by ss.zsid) as fu,
sum(ss.bb) over (partition by ss.zsid order by ss.zsid) as zheng
from
(
select m.zsid,
sum(n.f0004_028n) over(partition by m.zsid) n011,
sum(n.f0004_029n) over(partition by m.zsid) n012,
sum(n.f0004_030n) over(partition by m.zsid) n013,
sum(n.f0004_031n) over(partition by m.zsid) n014,
sum(n.f0004_032n) over(partition by m.zsid) n015,
sum(n.f0004_033n) over(partition by m.zsid) n021,
sum(n.f0004_034n) over(partition by m.zsid) n022,
sum(n.f0004_035n) over(partition by m.zsid) n023,
n.f0004_017n,
(case when n.f0004_017n>0 then 1 when n.f0004_017n<=0 then 0 end) aa,
(case when n.f0004_017n<=0 then 1 when n.f0004_017n>0 then 0 end) bb
from (select a.f0055_001n zsid,
a.f0055_004v zsbm,
b.f0056_003v code,
b.f0056_004v zsjycs, --指数交易场所
b.f0056_005v zszqlb, --指数证券类别
c.f0005_005v codezqlb, --成份股证券类别
c.f0005_007v codejycs --成份股交易场所
from tb_index_0055@p1 a, tb_index_0056@p1 b, tb_public_0005@p1 c
where b.f0056_001d = to_date('20100106', 'yyyymmdd') --交易日
and b.f0056_003v = c.f0005_001v
and a.f0055_001n = b.f0056_002n) m,
tb_ori_0004 n
where m.code = n.f0004_005v
and m.codezqlb = n.f0004_004v
and m.codejycs = n.f0004_003v
and n.f0004_001d = to_date('20100106', 'yyyymmdd')
and n.f0004_002v = '1102' --当前时间点
order by m.zsid asc, m.code asc
)ss
where ss.zsid=1
- ORACLE 统计正负个数sql
- 统计正负数个数
- 正负数、0,个数的统计
- 80x86 汇编语言:正负数分别存放、统计个数
- ORACLE 正负数分开排序 SQL
- oracle sql 分组统计
- oracle分组统计sql
- Oracle 报表统计SQL
- oracle统计sql
- oracle统计某个用户的对象个数
- oracle-统计---=sql comp
- Oracle按时间统计sql
- 统计个数
- 统计个数
- 统计个数
- SQL Server统计数据库中表个数、视图个数、存储过程个数
- Oracle 递归统计所有节点下的子节点个数
- Oracle 统计数据库 表的个数和名字
- Writing Papers in the United States—A Guide for Foreign Students
- wndows头文件中提供的位运算宏及地址强转操作符的小节(BYTE,WORD,DWORD,MAKEWORD,LOWORD,LOBYTE.....)
- jsp的指令与动作标签进行include对性能的影响性能
- java.security.MessageDigest的使用(2),生成安全令牌!
- IPsec in linux-2.6(一)
- ORACLE 统计正负个数sql
- programmin windows with MFC 读书笔记一
- Delphi 关键字详解
- Wicd - Wired and Wireless Network manager for Ubuntu
- Detours中文帮助
- KMP 算法原理
- java更新xml步骤
- 物料帐
- 索引 的使用场合