涉及到之前博文写到的sc表,自身嵌套查询
直接上代码
select distinct sno as 学号
from sc
where cno='C001'and sno in (
select distinct sno
from sc
where cno='C002'
)
distinct 去重的作用
涉及到之前博文写到的sc表,自身嵌套查询
直接上代码
select distinct sno as 学号
from sc
where cno='C001'and sno in (
select distinct sno
from sc
where cno='C002'
)
distinct 去重的作用