SQL server查询有成绩的学生信息

表：

course

score

student

teacher

查询思路

1.表“score”里面的学生都是有成绩的学生；

2.直接关联表“student”和表“score”；

3.筛选出有成绩的学生。

代码段：

SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别
FROM student
LEFT JOIN score ON student.SId=score.SId
WHERE student.SId=score.SId
GROUP BY student.SId,student.Sname,student.Sage,student.Ssex

-----------------------------------------------初级程序员心得，欢迎批评指正---------------------------------------