你可能感兴趣的试题
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 ’王_’
(Sno,Tno)和{Cno,Cname,Grade,Tno,Tname} (Sno, Cno, Tno)和{Sno, Sname, Sex, Birthday, Cno} (Sno, Cno)和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade} (Sno, Cno, Tno)和{Sno, Sname, Sex, Birthday, Tno, Tname}
(Sno,Tno)和Cno,Cname,Grade,Tno,Tname (Sno, Cno,Tno) 和Sno, Sname, Sex, Birthday, Cno (Sno, Cno)和Sno, Sname, Sex, Birthday, Cno, Cname, Grade (Sno, Cno,Tno)和Sno, Sname, Sex, Birthday, Tno, Tname
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′王_′
1个,为(Sno,Cno) 1个,为(Sno,Cno,Tname) 2个,为(Sno,Sname,Cno)和(Sno,Cno,Tname) 2个,为(Sno,Sname,Cno)和(Sno,Cno,Tnam
(Sno,Tno)和{Cno,Cname,Grade,Tno,Tname} (Sno, Cno,Tno) 和{Sno, Sname, Sex, Birthday, Cno} (Sno, Cno)和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade} (Sno, Cno,Tno)和{Sno, Sname, Sex, Birthday, Tno, Tname}
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 ’王_’
(Sno,Tno)和Cno,Cname,Grade,Tno,Tname (Sno,Cno,Tno)和Sno,Sname,Sex,Birthday,Cno (Sno,Cno)和Sno,Shame,Sex,Birthday,Cno,Cname,Grade (Sno,Cno,Tno)和Sno,Sname,Sex,Birthdayr,Tno,Tname
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 R WHERsno='2003%' SELECT sname FROM R WHERE sno LIKE '2003%' SELECT sname FROM R WHERE sno='2003_' SELECT sname FROM R WHERE sno LIKE '2003_'
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′王_′