1.查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数
时间: 2023-11-28 18:03:50 浏览: 62
要查询"01"课程比"02"课程成绩高的学生的信息及课程分数,可以使用以下SQL语句:
SELECT student.*, sc1.score AS '01课程成绩', sc2.score AS '02课程成绩'
FROM student
JOIN sc AS sc1 ON student.s = sc1.s AND sc1.c = '01'
JOIN sc AS sc2 ON student.s = sc2.s AND sc2.c = '02'
WHERE sc1.score > sc2.score;
这条SQL语句中,使用了JOIN语句将student表与sc表连接起来,通过比较"01"课程成绩(sc1.score)和"02"课程成绩(sc2.score)来筛选出成绩高的学生。同时,通过SELECT语句选择了需要的字段,包括学生的信息(student.*),以及"01"课程和"02"课程的成绩(sc1.score和sc2.score)。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [数据库 练习(五)](https://blog.csdn.net/weixin_45615602/article/details/102767291)[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: 100%"]
[ .reference_list ]