你可能感兴趣的试题
SELECT S#，SNAME FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#=’C2’) SELECT S#，SNAME FROM S，SC WHERE S#=SS# AND C#=’C2’ SELECT S#，SNAME FROM S，SC WHERE S#=SS# AND C#=‘C2’ORDER BY S# SELECT S#，SNAME FROM S WHERE S# IN(SELECT SS# FORM SC WHERE C#=‘C2’)
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 sname＝’王’ SELECT sno FROM sc WHERE sname IS LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王%’ SELECT sno FROM sc WHERE sname LIKE ’王_’
SELECT S#，SNAME FROM S WHERE SNAME=’李％’ SELECT S#，SNAME FROM S WHERE SNAME LIKE’李％’ SELECT S#，SNAME FROM S WHERE SNAME=’％李％’ SELECT S#，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,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 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′王_′
SELECT S#,SNAME FROM S WHERE S#=(SELECT SS# FROM SC WHERE C#=/’C2/’) SELECT S#,SNAME FROM S,SC WHERE S#=SS# AND C#=/’C2/’ SELECT S#,SNAME FROM S,SC WHERE S#=SS# AND C#=/’C2/’ORDER BYS# SELECT S#,SNAME FROM S WHERE S# IN(SELECT SS# FROM SC WHERE C#=/’C2/’)
湘公网安备 43130202000226号