你可能感兴趣的试题
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 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 FROM SC WHERE CNO=′DB′AND GRADE DETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′OR GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＞=60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＜=60 AND GRADE＞=90
SELECT s. sname FROM s, sc WHERE c. cno＝’C1’ SELECT s. sname FROM s, sc WHERE c. cno=’C1’AND s. sno＝sc. sno SELECT s. sname FROM s, sc FOR c. cno＝’C1’ SELECT s. sname FROM s, sc FOR c. cno＝’C1’ AND s. sno=sc. sno
SELECT sno FROM sc WHERE grade＝NULL SELECT sno FROM sc WHERE grade IS SELECT sno FROM sc WHERE grade IS NULL SELECT sno FROM sc WHERE grade＝0
SELECT sno FROM sc WHERE grade=NULL SELECT sno FROM sc WHERE grade IS SELECT sno FROM sc WHERE grade IS NULL SELECT sno FROM sc WHERE grade=0
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 FROMSC WHERE CNO＝’DB’ AND GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO＝’DB’ OR GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO＝’DB’ AND GRADE＞=60 AND 90 SELECTSNO FROM SCWHERECNO＝’DB’ AND GRADE＜＝60 AND GRADE＞＝90
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 CNO=′DB′AND GRADE DETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′OR GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＞=60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＜=60 AND GRADE＞=90
SELECT sno FROM sc WHERE grade=NULL SELECT sno FROM sc WHERE grade IS SELECT sno FROM sc WHERE grade IS NULL SELECT sno FROM sc WHERE grade=0
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 FROMSC WHERE CNO＝’DB’ AND GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO＝’DB’ OR GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO＝’DB’ AND GRADE＞=60 AND 90 SELECTSNO FROM SCWHERECNO＝’DB’ AND GRADE＜＝60 AND GRADE＞＝90
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 s.sname FROM s,sc WHERE c.cno=′C1′ SELECT s.sname FROM s,sc WHERE c.cno=′C1′AND s.sno=sc.sno SELECT s.sname FROM s,sc FOR c.cno=′C1′ SELECT s.sname FROM s,sc FOR c.cno=′C1′AND s.sno=sc.sno
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 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号