75页第5题
1、
select sno
from spj
where jno='j1';
2、
select sno
from spj
where jno='j1' and pno='p1';
3、
select sno
from spj,p
where spj.pno=p.pno and jno='j1' and color='红';
4、
select jno
from s,spj,p
where s.city not like '天津'and p.color='红'and s.sno=spj.sno and p.pno=spj.pno;
5、
select distinct jno
from spj spj1
where not exists
( select *
from spj spj2
where spj2.sno='s1' and
not exists
( select *
from spj spj3
where spj3.jno=spj1.jno and
spj3.pno=spj2.pno
)
本内容试读结束，登录后可阅读更多
下载后可阅读完整内容，剩余2页未读，立即下载
