oracle订单查询sql一例
来源:互联网 发布:mac chrome flash 编辑:程序博客网 时间:2024/06/02 15:58
select a1.username,nvl(a2.sum1,0) ,nvl(a3.sum2,0) ,nvl(sum1,0)-nvl(sum2,0) as num1 from member a1
left join(
select b.member_id,nvl(sum(a.sum_money),0) as sum1 from reserve_list a
inner join reserve b
on a.reserve_id=b.id
where substr(create_time,4,2)=11
group by b.member_id
)a2
on a1.id=a2.member_id
left join(
select b.member_id,sum(a.sum_money) as sum2 from reserve_list a
inner join reserve b
on a.reserve_id=b.id
where substr(create_time,4,2)=12
group by b.member_id
)a3
on a1.id=a3.member_id
order by num1 desc
left join(
select b.member_id,nvl(sum(a.sum_money),0) as sum1 from reserve_list a
inner join reserve b
on a.reserve_id=b.id
where substr(create_time,4,2)=11
group by b.member_id
)a2
on a1.id=a2.member_id
left join(
select b.member_id,sum(a.sum_money) as sum2 from reserve_list a
inner join reserve b
on a.reserve_id=b.id
where substr(create_time,4,2)=12
group by b.member_id
)a3
on a1.id=a3.member_id
order by num1 desc
- oracle订单查询sql一例
- oracle----sql查询(一)
- Oracle SQL数据操作和查询(一)
- oracle数据库SQL查询语句练习一
- oracle中sql语句查询优化(一)
- oracle并行查询一例
- oracle并行查询一例
- oracle并行查询一例
- oracle并行查询一例
- ORACLE 数据库的级联查询 一句sql搞定(例:部门多级,类型多级)
- 一分钟搞懂mysql、oracle、sql server分页查询
- Magento 根据SKU查询订单信息的SQL语句
- oracle----sql----查询---为例---计算
- oracle SQL树查询
- Oracle SQL查询练习题
- oracle sql 时间查询
- oracle sql查询日历
- oracle 高级SQL查询
- 腊八节、腊八粥
- capistrano中的脚本使用
- 分享我的胜利果实:成功使用JDBC 1.2连接SQL Server 2005
- 集合(collection)和枚举(enumerator)
- 学习中.....
- oracle订单查询sql一例
- c++ 嵌入式开发
- 学习游戏制作从哪里开始
- VC设置注册表启动项目
- [转]通过Live Writer Blog客户端来写blog
- 用linux收集证据的一般程序
- 火星车与COM组件
- squid quick start
- 关于Ruby on Rails的几篇文章收集