执行SQL语句SELECTSNAMEAGEFROMSWHERESEX='女'则该语句对关系S执行的操-X题卡

查询选修了课程号为C1的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SELECT SNAME，AGE FROM S WHERE S．S#=(SELECT S S#FROM SC WHERE C#='C1') SELECT SNAME，AGE FROM S，SC WHERE S．S#=S S# AND S C#='C1' SELECT SNAME，AGE FROM S，SC WHERE S．S#=S S# AND S C#='C1' ORDERBY S．S# SELECT SNAME，AGE FROM S WHERE

查询选修了课程号为C1的学生的姓名和年龄若用下列SQL的SELECT语句表达时哪一个是错误的

SELECT SNAME，AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C1') SELECT SNAME，AGE FROM S，SC WHERE S#=SS# AND SC#='C1' SELECT SNAME，AGE FROM S，SC WHERE S#=SS# AND SC#='C1'ORDER BY S# SELECT SNAME，AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE SC#='C1')

有学生信息表student求年龄在20岁到22岁之间含20岁和22岁的学生姓名和年龄的SQL语句是

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁于22岁之间的学

SELECT * FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age＞=20 SELECT sname，sno FROM student WHERE age＜=22

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁至22岁之间的学

SELECT*FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age>=20 SELECT sname，sno FROM student WHERE age<=22

查询选修了课程号为MATHS的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SEIECT SNAME, ADE FROM S WHERE S#=(SELECT S S# FROM SC WHERE C#='MATHS') SELECT SNAME, AGE FROM S WHERE S#=(SELECT S S# FROM SC WHERE S C#='MATHS') SELECT SNAME, AGE FROM S, SC WHERE S#=SS# AND S C#='MATHS' ORDER BY S# SELECT SNAME, AGE FROMS, SC WHERE S#=SS# AND SC#='MATHS'

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁于22岁之间的学

SELECT * FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age＞＝20 SELECT sname，sno FROM student WHERE age＜＝22

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁到22岁之间的学

SELECT*FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age＞＝20 SELECT sname，sno FROM student WHERE age＜＝22

查询选修了课程号为C1的学生的姓名和年龄若用下列SQL的SELECT语句表达时哪一个是错误的

SELECT SNAME，AGE FROM S WHERE  S．S#
=(SELECT S  S# FROM SC WHERE  C#='C1')  SELECT SNAME，AGE FROM S，SC
WHERE  S．S#=S  S# AND S  C#='C1'  SELECT SNAME，AGE FROM S，SC
  SELECT SNAME，AGE FROM S WHERE  S．S#<

在学生—选课—课程数据库中的两个关系如下SSNOSNAMESEXAGESCSNOCNOGRADE若使

在学生-选课-课程数据库中如下三个关系 SS#SNAMESEXAGE SCS#C#GRADE

SELECT SNAME，AGE FROM S WHERE S．S# 　　=(SELECT S S# FROM SC WHERE C#='C1') SELECT SNAME，AGE FROM S，SC 　　WHERE S．S#=S S# AND S C#='C1' SELECT SNAME，AGE FROM S，SC 　　WHERE S．S#=S S# AND S C#='C1'ORDER BY S．S# SELECT SNAME，AGE FROM S WHERE

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁到22岁之间的学

SELECT * FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age＞=20 SELECT sname，sno FROM student WHERE age＜=22

有学生信息表student求年龄在20岁到22岁之间含20岁和22岁的学生姓名和年龄的SQL语句是S

设有学生数据库studentsnosnamesexagedept现要查询所有刘姓学生的信息可使用如下

查询选修了课程号为MATHS的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT SC.S#FROM SC WHERE C.C#='MATHS') SELECT SNAME,AGEFROM SWHERE S.S#=(SELECT SC.S#FROM SC WHERE SC.C#='MATHS') SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS' ORDER BY S.S# SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS'

若要求查找年龄大于18岁学生的学生号和姓名正确的SQL语句是

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'

在学生—选课—课程数据库中的两个关系如下 SSNOSNAMESEXAGESCSNOCNOGRADE

下列题基于学生—选课—课程数据库中的三个关系SS#SNAMESEXAGESCS#C#GRADECC#

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’

已知有关系模式Rsnosnameage其中sno表示学生的学号类型为Char8前4位表示入学年份查询

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_'

若要求查找年龄大于18岁学生的学生号和姓名正确的SQL语句是

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'

执行SQL语句：SELECT SNAME，AGE FROM S WHERE SEX='女'。则该语句对关系S执行的操作有( )。

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库