nig001 最近的时间轴更新 nig001 最近的时间轴更新 |
nig001V2EX 第 262705 号会员，加入于 2017-10-26 15:07:20 +08:00 |
nig001 最近回复了
2022-11-18 11:59:47 +08:00 回复了 qiyong 创建的主题 › 程序员 › 面试中遇到的一道 sql 题 |
SELECT a.id,a.name,c.sales_volume,gb.group_name,gb.g_sales_volumes FROM goods a LEFT JOIN goods_sales_record c ON a.id = c.goods_id LEFT JOIN (SELECT b.id as group_id,b.name AS group_name,sum(c.sales_volume) AS g_sales_volumes FROM goods_sales_record c LEFT JOIN goods a ON a.id=c.goods_id LEFT JOIN goods_group b ON a.group_id = b.id GROUP BY b.id) gb ON a.group_id = gb.group_id ORDER BY gb.g_sales_volumes,c.sales_volume DESC LIMIT 3
2020-08-03 14:43:53 +08:00 回复了 KalaSearch 创建的主题 › 程序员 › 优秀的 REST API 设计指南 |
不错的
Select Language