学生课程成绩表sql
时间: 2023-09-22 09:06:14 浏览: 57
学生课程成绩表的SQL查询语句可以使用以下示例来实现:
SELECT student.Sno AS 学号, student.Sname AS 姓名, course.Cno AS 课程号, SC.score AS 成绩
FROM student, SC, course
WHERE student.Sno = SC.Sno AND SC.Cno = course.Cno;
这个查询语句通过使用INNER JOIN将学生表(student)、成绩表(SC)和课程表(course)进行连接,然后选取需要显示的列(学号、姓名、课程号、成绩)。使用WHERE子句来指定连接条件(student.Sno = SC.Sno AND SC.Cno = course.Cno)。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [sql面试题一 学生成绩](https://blog.csdn.net/weixin_30879833/article/details/95486190)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [SQL的学习学生表](https://blog.csdn.net/cmnokk/article/details/127513833)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]