你可能感兴趣的试题
SELECT SNO,SNAME FROMSWHERE SNAME＝’王%’ SELECT SNO,SNAME FROM S WHERE SNAME＝’王_’ SELECT SNO,SNAMEFROMS WHERE SNAME LIKE ’王%’ SELECT SNO,SNAME FROM S WHERE SNAME LIKE ’王_’
SELECT SNAME FROM S,SC,C WHERE S.SNO=SSNO AND SCNO=CNO AND CNAME=′DB′ SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC,C WHERE SCNO=CNO AND CNAME=′DB′) SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC WHERE CNO IN(SELECT CNO FROM C WHERE CNAME=′DB′) ) SELECT SNAME FROM S,C WHERE CNAME=′DB′
SELECT sname FROM student，SELECT cno，grade FROM sc WHERE studensno＝ssno SELECT sname，cno，grade FROM student，course WHERE studensno＝courscno SELECT sname，cname，grade FROM student，course，sc WHERE studensno＝ssno and scno＝course，cno SELECT sname，cno，grade FROM student，sc WHERE studensno＝ssno
SELECT SNO,SNAME FROM S WHERE SNAME=′王%′ SELECT SNO,SNAME FROM S WHERE SNAME=′王_′ SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′ SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′
Mno=’CS’ Mno≠’CS’ Mno＜＞’CS’ Mno IS NOT ’CS’
πSno，Mno（S） σSno，Mno（S） Sno∪Mno Sno×Mno
SELECT sno FROM sc WHERE sname＝’王’ SELECT sno FROM sc WHERE sname IS LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王_’
SELECT sno FROM sc WHERE sname=′王′ SELECT sno FROM sc WHERE sname IS LIKE′王%′ SELECT sno FROM sc WHERE sname LIKE′王%′ SELECT sno FROM sc WHERE sname LIKE′王_′
SELECT sno FROM sc WHERE sname＝’王’ SELECT sno FROM sc WHERE sname IS LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王_’
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 SNO,SNAME FROM S WHERE SNAME=′王%′ SELECT SNO,SNAME FROM S WHERE SNAME=′王_′ SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′ SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′
SELECT SNO,SNAME FROMSWHERE SNAME＝’王%’ SELECT SNO,SNAME FROM S WHERE SNAME＝’王_’ SELECT SNO,SNAMEFROMS WHERE SNAME LIKE ’王%’ SELECT SNO,SNAME FROM S WHERE SNAME LIKE ’王_’
SELECT SNAME FROM S,SC,C WHERE SNO=SSNO AND SCNO=CNO AND CNAME=′DB′ SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC,C WHERE SCNO=CNO AND CNAME=′DB′) SELECT SNAME FROM S WHERE SNO IN(SELECT SNO FROM SC WHERE CNO IN(SELECT CNO FROM C WHERE CNAME=′DB′) ) SELECT SNAME FROM S,C WHERE CNAME=′DB′
SELECT S#，SNAME FROM S WHERE AGE>18 SELECT S#，SNAME FROM S WHERE AGE>=18 SELECT S#，SNAME FROM S WHERE AGE>’18’ SELECT S#，SNAME FROM S WHERE AGE>=’18’
SELECT sno FROM sc WHERE sname=′王′ SELECT sno FROM sc WHERE sname IS LIKE′王%′ SELECT sno FROM sc WHERE sname LIKE′王%′ SELECT sno FROM sc WHERE sname LIKE′王_′
湘公网安备 43130202000226号