经典SQL面试50题
# Q1
# 查询"01"课程比"02"课程成绩高的学生的信息及课程分数
# 左连接自交
select *
from Student as s
right join
(
select t1.SId, score_for_c01, score_for_c02
from (select SId, score as score_for_c01 from SC as sc where sc.CId = 01) as t1,
原创
2021-02-23 17:57:32 ·
203 阅读 ·
0 评论