SQLserver中三个表的查询,去重复与计算平均值

2025-03-28 20:38:15
推荐回答(1个)
回答1:

select t1. mingchen,avg(t2.fenshu)
from zhibiao as t1
inner join pingjia_xuanxian as t2
on t1.id=t2.id
group by t1.mingchen