- 查询至少有一门课与学号为" 01 "的同学所学相同的同学的信息
SELECT * from Student WHERE SId in
(SELECT SId from sc WHERE cid in (SELECT cid from sc WHERE sid='01'))
2024-01-09 14:28:34
SELECT * from Student WHERE SId in
(SELECT SId from sc WHERE cid in (SELECT cid from sc WHERE sid='01'))