你可能感兴趣的试题
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 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 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号