mysql 复杂查询

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql 复杂查询，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1982字，纯文字阅读大概需要3分钟。

内容图文

, product_id, product_name, count(op.number ) as number, -- sum(total_amount + point_total_amount/10) as total_amount, -- sum(point_total_amount) as point_total_amount -- from -- -- (select * from orders where (status = ‘completed‘ and (refund_status in (‘refunded‘,‘not_apply‘))) or refund_status = ‘refunded‘) as o -- -- left join order_products as op on op.order_id = o.id -- left join users as u on u.id = o.user_id -- -- -- group by product_id -- -- o.user_id -- -- group by user_id -- order by product_id -- )

 

(select 
order1.user_id as user_id, 
product_id, 
product_name,
count(op.number ) as number, 
sum(total_amount + convert( point_total_amount/10, decimal)) as total_amount,
sum(point_total_amount) as point_total_amount  
from 
(select * from orders where (status = ‘completed‘ and (refund_status in (‘refunded‘,‘not_apply‘))) or refund_status = ‘refunded‘) as order1
left join order_products as op on op.order_id = order1.id 
left join users as u on u.id = order1.user_id
group by user_id,product_id
order by user_id
)

UNION All

select null,user_id, realname, IFNULL(null,‘合计‘)  ,count(*) as number, sum(total_amount) as total_amount 
from
(
select 
order1.user_id as user_id, 
product_id, 
product_name,
count(op.number ) as number, 
sum(total_amount + convert( point_total_amount/10, decimal)) as total_amount,
sum(point_total_amount) as point_total_amount  
from 
(select * from orders where (status = ‘completed‘ and (refund_status in (‘refunded‘,‘not_apply‘))) or refund_status = ‘refunded‘) as order1

left join order_products as op on op.order_id = order1.id 

group by user_id,product_id
order by user_id
) as new
left join users as u on u.id = new.user_id
GROUP BY new.user_id

 

mysql 复杂查询

标签：rom   div   group   查询   nio   mount   pre   apply   products   

本文系统来源：http://www.cnblogs.com/smallyi/p/7412341.html

内容总结

以上是互联网集市为您收集整理的mysql 复杂查询全部内容，希望文章能够帮你解决mysql 复杂查询所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---