水平拆分连接查询语句

甲骨文数据库

于 2025-04-04 01:22:53 发布

阅读量72

点赞数 2

文章标签： sql

本文链接：https://blog.youkuaiyun.com/www_oracle_com/article/details/146991909

版权

select * from (select *,volume - lag(volume,1,0) over (partition by InstrumentID,tradingday order by InstrumentID asc, tradingday asc , volume asc ) as tmpvol from (select * from t_m5 union all select * from t_m6 ) as t_m56 ) as tmp_t1 where  tmpvol > 0 order by instrumentid asc, tradingday asc, Volume asc