—isitfromyourschooltothenearestpark—Abouttenminute-X题卡

设有关系模式SCsnocnograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)

已知关系模式scsnosnamegrade各属性含义依次为学号课程名分数要查找数据库课分数最高的学生

SELECT sno FROM sc WHERE sname = "数据库" AND grade = MAX(grade) SELECT sno FROM sc FOR sname = "数据库" OR grade＞=MAX(grade) SELECT sno FROM sc WHERE sname = "数据库" AND grade = (SELECT MAX(grade) FROM sc) SELECT sno FROM sc FOR sname = "数据库" OR grade = (SELECT MAX(grade) FROM sc)

对于教学数据库的三个基本表SSnoSnameSsexSCSnoCnoGradeCCnoCnameTe

SELECT Sname FROM S，SC，C WHERE S Sno=SC.Snn AND SC.Con=C.Con And Teacher='LTU' AND Seex='F' SELECT Sname FROM S WHERE Ssex='F' AND Sno IN (SELECT Sno FROM SC WHERE(Cno IN(SELECT Cno FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHERE Ssex='F' AND EXISTS(SELECT* FROM SC WHEPE SC.Sno=S. Sno AND EXISTS (SELECT* FROM C WHERE Teacher='LIU')) SELECT Sname FROM S WHEPE Ssex='F' AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT* FROM C WHERE C Cno=SC Cno AND Teacher='LIU'))

从学生选课信息表中找出无成绩的元组的SQL语句是

SELECT * FROM sc WHERE grade=NULL SELECT *FROM sc WHERE grade IS'' SELECT *FROM sc WHERE grade IS NULL SELECT *FROM sc WHERE grade=''

查询选修了课程号为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'

设有关系模式SCsnoenograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno="c1"AND cno="c2" SELECT sno FROM sc WHERE cno="cl'，AND SELECT sno FROM sc WHERE cno="c2" SELECT sno FROM sc WHERE cno="cl" UNION SELECT sno FROM sc WHER：E cno="c2" SELECT sno FROM sc WHERE cno="cl"AND sno IN(SELECT sno FROM sc WHERE cno="c2")

已知关系模式scsnosnamegrade各属性含义依次为学号课程名分数要查找数据库课分数最高的学生

SELECT sno FROM SC WHERE sname="数据库"AND grade=MAX(grade) SELECT sno FROM SC FOR sname="数据库"OR grade＞MAX(grade) SELECT sno FROM SC WHERE shame="数据库"AND grade=(SELECT MAX(grade)FROM sc) SELECT son FROM SC FOR sname="数据库"OR grade=(SELECT MAX(grade. FROM sc)

设有s学号姓名性别和sc学号课程号成绩两个表如下SQL语句检索选修的每门课程的成绩都高于或等于85分

SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩>85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩<85)

学生选课信息表scsnocnograde主键为snocno从学生选课信息表中找出无成绩的元组的SQL

SELECT * FROM sc WHERE grade=NULL SELECT * FROM sc WHERE grade IS “ ” SELECT * FROM sc WHERE grade=‘ ’ SELECT * FROM sc WHERE grade IS NULL

检索选修课程C2的学生中成绩最高的学生的学号正确的SELECT的语句是______

SELECT S# FROM SC WHERE C#="C2" AND GRADE＞ =(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2") SELECT S# FROM SC WHERE C#="C2" AND GRADE＞ =ALL(SELECT GRADE FROM SC WHERE C#="C2")

用SQL命令查旬选修的每门课程的成绩都高于或等于85分的学生的学号和姓名正确的命令是

SELECT 学号，姓名 FROM S WHERE NOT EXISTS； (SELECT * FROM SC WHERE SC 学号=S.学号 AND 成绩＜85) SELECT 学号，姓名 FROM S WHERE NOT EXISTS； (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩＞=85) SELECT 学号，姓名 FROM S，SC WHERE S.学号=SC.学号 AND 成绩＞=85 SELECT 学号，姓名 FROM S，SC WHERE S.学号=SC.学号 AND ALL 成绩＞=85

设有关系模式SCsnocnograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)

设学生表S课程表C和学生选课表SC的结构如下S学号姓名年龄系别C课程号课程名SC学号课程号成绩查询学

SELECT S.姓名，SC.课程号，SC.成绩FROM S WHERES.学号＝SC.学号 SELECT S.姓名，SC.课程号，SC.成绩FROM SC WHERES.学号＝SC.成绩 SELECT S.姓名，SC.课程号，SC.成绩FROM S，SC WHERE S.学号＝SC.学号 SELECT S.姓名，SC.课程号，SC.成绩FROM S，SC

已知基本表SCS#C#GRADE则统计选修了课程的学生人次数的SQL语句为

SELECT COUNT(DISTINCTS#)/FROM SC SELECT COUNT(S#)/FROM SC SELECTCOUNT(*)/FROM SC SELECT COUNT (DISTINCT*)/FROM SC

对于教学数据库的三个基本表SSnoSnameSsexSCSnoCnoGradeCCnoCnameTe

SELECT Sname FROM S，SC，C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’ SELECT Sname FROM S WHERE Ssex=‘F’AND Sno IN (SELECT Sno FROM SC WHERE Cno IN(SELECT Cno FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC.Sno=S.Sno AND EXISTS (SELECT * FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS( SELECT * FROM SC WHERE SC Sno=S Sno AND EXISTS (SELECT * FROM C WHERE C.Cno=SC.Cno AND Teacher=‘LIU’))

设有s学号姓名性别和sc学号课程号成绩两个表如下SQL语句检索选修的每门课程的成绩都高于或等于85分

SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩>85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩<85)

设有S学号姓名性别和SC学号课程号成绩两个表如下SQL语句检索选修的每门课程的成绩都高于或等于85分

SELECT学号，姓名，性别FROM s WHERE EXISTS(SELECT*FROM sc WHERE SC.学号=S.学号AND成绩＜=85) SELECT学号，姓名，性别FROM s WHERE NOT EXISTS(SELECT*FROM sc WHERE SC.学号=S.学号AND成绩＜=85) SELECT学号，姓名，性别FROM s WHERE EXISTS(SELECT*FROM sc WHERE SC.学号=S.学号AND成绩＞85) SELECT学号，姓名，性别FROM s WHERE NOT EXISTS(SELECT*FROM sc WHERE SC.学号=S.学号AND成绩＜85)

设有s学号姓名性别和sc学号课程号成绩两个表如下SQL语句检索选修的每门课程的成绩都高于或等于85分

SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=s.学号 AND 成绩<=85) SELECT 学号,姓名,性别 FROM S WHERE EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩>85) SELECT 学号,姓名,性别 FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE SC.学号=S.学号 AND 成绩<85)

从学生选课信息表中找出无成绩的元组的SQL语句是

SELECT*FROM sc WHERE grade＝NULL SELECT*FROM sc WHERE grade IS" SELECT*FROM sc WHERE grade IS NULL SELECT*FROM sc WHERE grade=/

己知基本表SCS#C#GRADE则统计选修了课程的学生人次数的SQL语句为

SELECT COUNT(DISTINCT S#)FROM SC SELECT COUNT(S#)FROM SC SELECT COUNT(*)FROM SC SELECT COUNT(DISTINCT)FROM SC

— is it from your school to the nearest park？ — About ten minutes’ walk.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库