如果每个学生都有通知单,从学生表统计就可以了
select nj,zydm,count(*) as c from Fina_Student group by nj,zydm否则
select a.nj,a.zydm,count(distinct b.StuTuitionID) as c from Fina_Student a left join Fina_Must b on a.StuTuitionID=b.StuTuitionID
select nj,zydm,count(*) as c from Fina_Student group by nj,zydm否则
select a.nj,a.zydm,count(distinct b.StuTuitionID) as c from Fina_Student a left join Fina_Must b on a.StuTuitionID=b.StuTuitionID
select count(nj ), from Fina_Student
group by zydmselect count(zydm), from Fina_Student
group by nj
set
Fina_Student.zydm=Fina_Must.SpeciltyID
from Fina_Student,Fina_Must
where Fina_Must.StuTuiTionID=Fina_Student.StuTuiTionID
那就先更新先
group by nj
这个没错吧
from fina_must
where id in ( select min(id)
from fina_must
group by grade,speciltyid
)
group by grade,speciltyid
这位朋友,你这样只能得到一个ID.