mysql 父级和子级的求和sql

最新推荐文章于 2024-11-11 23:47:19 发布

chuaigui3730

最新推荐文章于 2024-11-11 23:47:19 发布

阅读量670

点赞数 1

文章标签：数据库

原文链接：https://my.oschina.net/u/1260823/blog/715081

版权

本文详细解析了一段复杂的SQL查询代码，旨在展示如何通过多表联接和子查询实现用户支付金额的汇总统计。该查询涉及到对userpay和userinfo表的深入操作，包括分组、聚合函数SUM的使用，以及通过子查询处理多层级的用户关系。

摘要由CSDN通过智能技术生成

查询sql

SELECT z.username,SUM(z.payprice) FROM (
SELECT up.username,SUM(payprice) AS payprice FROM userpay up
JOIN (SELECT username FROM userpay GROUP BY username ) n
WHERE up.username = n.username GROUP BY up.username
UNION ALL
SELECT n.username ,SUM(payprice) AS payprice
FROM userpay up JOIN (SELECT username FROM userpay GROUP BY username) n
WHERE up.`username` IN (SELECT u1.username FROM userinfo u1 WHERE u1.`parent_name` = n.username)
GROUP BY n.username
) z GROUP BY z.username

查询的结果集