/*
例如求每科的平均分
t_subject 科目
t_score 分数
*/
SELECT ts.*, t1.avgScore FROM (SELECT * FROM t_subject) AS ts
LEFT JOIN (
SELECT
tss.subject_id,
AVG(tss.score) AS avgScore
FROM t_score AS tss
GROUP BY tss.subject_id /*用科目ID分组 求每个科目的总分数*/
) AS t1 ON ts.id = t1.subject_id
sql笔记 例如每科平均成绩,统计每笔支付类型总计等
于 2022-06-21 14:56:58 首次发布