--檢索包含學號為101所學課程的學生學號--
select distinct 學號 from 成績表 as x where not exists 
     (select * from 成績表 as y where y.學號='101' and not exists
            (select * from 成績表 as z where z.學號=x.學號 and z.課號=y.課號))