一条牛B的SQL抵了我300多行的程序代码
select c.idkey,sum(c.totalMoney)from ((select b.rechargeway_idkey idkey, sum(b.payMoney) totalMoney
from mm_costMaster a left joinmm_memberPaymentWay b
on a.idkey = b.costMaster_idkey
where a.chargePerson ='chaos'
and a.accountNo is null and (a.costStatus=1 or a.costStatus=3)
and a.idkey = b.costMaster_idkey
group by b.rechargeway_idkey )
UNION
(select rechargeway_idkeyidkey, sum(rechargeMoney)totalMoney from mm_cardinfodetail
where accountNo is null and chargePerson ='chaos'
and rechargestatus_idkey = 1 group by rechargeway_idkey)
) c
group by c.idkey
select c.idkey,sum(c.totalMoney)
from (
(
select b.rechargeway_idkey idkey, sum(b.payMoney) totalMoney
from mm_costMaster a left join mm_memberPaymentWay b
on a.idkey = b.costMaster_idkey
where a.chargePerson ='chaos'
and a.accountNo is null and (a.costStatus=1 or a.costStatus=3)
and a.idkey = b.costMaster_idkey
group by b.rechargeway_idkey
)
UNION
(
select rechargeway_idkey idkey, sum(rechargeMoney) totalMoney from mm_cardinfodetail
where accountNo is null and chargePerson ='chaos'
and rechargestatus_idkey = 1 group by rechargeway_idkey
)
) c
group by c.idkey
今天写了300多行的代码，最后发现居然用一条sql语句就搞定了，这年头代码也太不值钱了吧！
sql真TMD的很强大，充分说明：没有做不到的，只有你想不到啊！
更多相关文章
- Mysql order by语句未使用索引的思考
- SQL语句练习(1)
- Android中RecyclerView的item中控件的点击事件添加删除一行、上
- Android Studio中如何编写JNI代码及编译so库
- 编译Android4.3内核源代码
- Java se之静态代码块、代码块、构造函数执行顺序问题
- Java普通代码块，构造代码块，静态代码块区别，执行顺序的代码实例
- 编写自己的代码库（javascript常用实例的实现与封装）[转]
- android应用如何在有需要时申请root权限？在程序中要调用哪些语句