你可能感兴趣的试题
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′王_′
SNO＝SC.SNO and SEX＝'女'and CNAME＝'计算机' SNO=SC.SNO and C.CNO＝SC.CNO and CNAME＝'计算机' SEX='女'and CNAME='计算机' SNO＝SC.SNO and C.CNO＝SC.CNO and SEX='女'and CNAME='计算机'
Sdept=’CS’ Sdept<>’CS’ ’Sdept’=CS ’Sdept’<>CS
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 ’王_’
Sdept=’CS’ Sdept＜＞’CS’ ’Sdept’=CS ’Sdept’＜＞CS
sno=sc.sno AND sex=′女′AND cname=′计算机′ sno=sc.sno AND c.cno=sc.cno AND cname=′计算机′ sex=′女′AND cname=′计算机′ sno=sc.sno AND c.cno=sc.cno AND sex=′女′AND cname=′计算机′
sno=sc.sno AND sex＝‘女’AND cname=‘计算机’ sno=sc.sno AND c.cno=sc.cno AND cname=‘计算机’ Sex＝‘女’AND cname＝‘计算机’ sno=sc.sno AND c.cno＝sc.cno AND sex=‘女’AND cname=‘计算机’
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 ’王_’
湘公网安备 43130202000226号