select后边查询的字段必须出现在 group by 后边。(聚合函数内的除外)
例:
select student.sname ,sc.sid ,count(sc.cid) ,sum(sc.score) from sc full join student on student.sid=sc.sid group by sc.sid, student.sname
select后边查询的字段必须出现在 group by 后边。(聚合函数内的除外)
例:
select student.sname ,sc.sid ,count(sc.cid) ,sum(sc.score) from sc full join student on student.sid=sc.sid group by sc.sid, student.sname