1查询成绩表的总分数,平均分,最低分和最高分。用sql语句怎么写?_百度...答:select stuid,name,sum(cast(score as bigint)) as allscore from stuscore group by stuid,name order by allscore desc 3. 计算每个人单科的最高成绩(要求显示字段: 学号,姓名,课程,最高成绩)SELECT t1.stuid,t1.name,t1.subject,t1.score from stuscore t1,(SELECT stuid,max(score) as ...
mysql中有student,course,scorse 三张表, 计算每个人单科的最高成绩(学...答:select sid,cid,max(score) from score group by cid;然后分别和学生表、课程表联合查询取出科目名字和学生名字就ok了 写成单条sql:select * from (select s.sid,s.realname,a.cid,a.mscore from student as s right join (select sid,cid,max(score) as mscore from score group by cid)...