数据人的经典SQL50题
sql经典五十题
– 1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数
select * from
(select * from
(select s_id,c_id, s_score from Score where c_id=01)a ,
(select c_id as n_id, s_score n_score from Score where c_id=02) b where a.s_score > b.n_score) c inner join student on c.s_
原创
2021-09-02 15:15:34 ·
563 阅读 ·
0 评论