数据库中有学生表StudentSnoSnameSsexSageSdept各属性分别表示为学号姓名性别-X题卡

数据库中有学生表StudentSnoSnameSsexSageSdept各属性分别表示为学号姓名性别

对于教学数据库的三个基本表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'))

数据库中有学生表StudentSnoSnameSsexSageSdept各属性分别表示学号姓名性别年

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

对于教学数据库的三个基本表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*

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

某数据库中有关系StudentSnoSnameSsexSageSdept各属性分别表示学号姓名性别年

对于教学数据库的三个基本表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 WHFRF Teacher=’LIU’)) SELECT Sname FROM S WHERE Ssex=’F’ AND EXISTS(SELECT* FROM SC WHERE SC.Sno=S.Sno AND EXISTS

用SQL语句创建简单数据表设教学管理数据库中有多张数据表其中学生表Student包括学生编号Sno学

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

数据库中有学生表StudentSnoSnameSsexSageSdept各属性分别表示为学号姓名性别

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

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

某数据库中有关系StudentSnoSnameSsexSageSdept各属性分别表示学号姓名性别年

对于教学数据库的3个基本表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 *

某数据库中有关系StudentSnoSnameSsexSageSdept各属性分别表示学号姓名性别年

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

对于教学数据库的三个基本表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’))

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

SELECT Sname FROM S，SC，C WHERE Sno=SSno AND SCno=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 SSno=Sno AND EXISTS (SELECT* FROM C WHERE Teacher=‘LIU’)) SELECT Sname FROM S WHERE Ssex=‘F’AND EXISTS(SELECT* FROM SC WHERE SSno=Sno AND EXISTS (SELECT* FROM C WHERE Cno=SCno AND Teacher=‘LIU’))

数据库中有学生表Student(Sno，Sname，Ssex，Sage，Sdept)，各属性分别表示为学号，姓名，性别，年龄，所在系；学生选课表SC(Sno，Cno，Grade)，各属性分别表示为学号...

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库