SELECT TYPE ,SUM(score) AS total FROM b
LEFT JOIN a ON a.name=b.name
GROUP BY TYPE
ORDER BY total DESC
写一句sql来统计字段type的总score并且按照总score倒叙排列
最新推荐文章于 2024-06-28 16:04:10 发布
SELECT TYPE ,SUM(score) AS total FROM b
LEFT JOIN a ON a.name=b.name
GROUP BY TYPE
ORDER BY total DESC