你可能感兴趣的试题
SELECT Sname FROM S，SC，C WHERE S Sno=SC.Snn AND SC.Con=C.Con And Teacher='LTU' AND Seex='F' SELECT Sname FROM S WHERE Ssex='F' AND Sno IN (SELECT Sno FROM SC WHERE(Cno IN(SELECT Cno FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHERE Ssex='F' AND EXISTS(SELECT* FROM SC WHEPE SC.Sno=S. Sno AND EXISTS (SELECT* FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHEPE Ssex='F' AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT* FROM C WHERE C Cno=SC Cno AND Teacher='LIU'))
SELECT Sname FROM S，SC，C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS (SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT*
advantage influence taste guard
SELECT Sname FROM S,SC,C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=’LIU’AND Ssex =’F’ SELECT Sname FROM S WHERE Ssex=’F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHFRF Teacher=’LIU’)) SELECT Sname FROM S WHERE Ssex=’F’ AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS
stay staying to stay stayed
SELECT Sname
FROM S，SC，C
WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher='LIU' AND Ssex='F' SELECT Sname
FROM S WHERE Ssex='F' AND Sno IN
(SELECT Sno
FROM SC
WHERE Cno IN(SELECT Cno FROM C
WHERE Teacher='LIU')) SELECT Sname
FROM S WHERE Ssex='F' AND EXISTS
(SELECT*
FROM SC
WHERE SC.Sno=S.Sno AND EXISTS
(SELECT*
FROM C
WHERE Teacher='LIU')) SELECT Sname
FROM S WHERE Ssex='F' AND EXISTS
(SELECT*
FROM SC
WHERE SC.Sno=S.Sno AND EXISTS
(SELECT*
FROM C
WHERE C.Cno=SC.Cno AND Teacher='LIU'))
affect effect move influence
SELECT Sname FROM S，SC，C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT * FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC Sno=S Sno AND EXISTS (SELECT * FROM C WHERE C.Cno=SC.Cno AND Teacher=‘LIU’))
SELECT Sname FROM S，SC，C WHERE Sno=SSno AND SCno=Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS (SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Cno=SCno AND Teacher=‘LIU’))
SELECT Sname
FROM S,SC,C
WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher='LIU'AND Ssex
='F' SELECT Sname
FROM S WHERE Ssex='F'AND Sno IN
(SELECT Sno
FROM SC
WHERE Cno IN(SELECT Cno FROM C
WHFRF Teacher='LIU')) SELECT Sname
FROM S WHERE Ssex='F' AND EXISTS(SELECT*
FROM SC
WHERE SC.Sno=S.Sno AND EXISTS
(SELECT*
FROM C
WHERE Teacher='LIU')) SELECT Sname
FROM S WHERE Ssex='F'AND EXISTS(SELECT*
FROM SC
WHERE SC.Sno=S.Sno AND EXISTS
(SELECT*
FROM C
WHERE C.Cno=SC.Cno AND
Teacher='LIU'))
湘公网安备 43130202000226号