你可能感兴趣的试题
shares receives makes offers
broke down broken in broken away from broken out
has hardly have hardly hardly has hardly have
Mrs King Mrs Brown Teacher King Miss King
shares receives makes offers
other another the other others
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’))
湘公网安备 43130202000226号