当前位置: X题卡 > 所有题目 > 题目详情

若给出关系Studen(t S_no, Sname, Sage, S_sex, SD_name, S_add, S_tel),并用SQL语言定义Student 关系如下: CREATE Studen...

查看本题答案

你可能感兴趣的试题

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′王_′  

热门试题

更多