A、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
B、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S2.Score > S1.Score;
C、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
D、Select * From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
创建测试数据 成绩表 SC create table SC(SId varchar(10),CId varchar(10),score decimal(18,1)) insert into SC values('01' , '01' , 80); insert into SC values('01' , '02' , 90); insert into SC values('01' , '03' , 99); insert into SC values('02' , '01' , 70); insert into SC values('02' , '02' , 60); insert into SC values('02' , '03' , 80); insert into SC values('03' , '01' , 80); insert into SC values('03' , '02' , 80); insert into SC values('03' , '03' , 80); insert into SC values('04' , '01' , 50); insert into SC values('04' , '02' , 30); insert into SC values('04' , '03' , 20); insert into SC values('05' , '01' , 76); insert into SC values('05' , '02' , 87); insert into SC values('06' , '01' , 31); insert into SC values('06' , '03' , 34); insert into SC values('07' , '02' , 89); insert into SC values('07' , '03' , 98);
A、INSERT INTO SC VALUES('200823','101',NULL,NULL);
B、INSERT INTO SC VALUES('201009','111',60,必修);
C、INSERT INTO SC VALUES(NULL,'103',80,'选修');
D、INSERT INTO SC VALUES('201132',NULL,86,'');
如下所示,创建表s,并完成随后的操作 Create table s(sno char(2) primary key,sname char(10)); 1.向表中添加属性列status,数据类型为int 2.向表中添加属性列city,数据类型为varchar(20),并限定其取值范围为“上海”,“北京”,“天津”之一 3.修改属性列status的数据类型为smallint 4.删除2.题中取值范围的约束 5.删除属性列status 6.如教材85页所示,建立student, sc, course等表,并插入若干数据,完成如下操作: (1)列出没有成绩的学生的学号和课程号 (2)列出2号课程成绩在70分到80分学生的学号 (3)查询所有2005级的学生的姓名,性别和所在系 (4)查询计科系2004级全体学生的所有信息 (5)查询计科系2006级3班和4班学生的姓名和性别 (6)查询所有以“数”打头的课程的名称和学分 (7)查询数学系所有学生的姓名,性别和出生年份 (8)将course表中名为PASCAL语言的课程更名为“C语言” (9)将所有课程的学分增加1分 (10)删除没有选课成绩的选课记录 (11)删除“IS”系的所有学生信息 (12)删除所有的课程信息
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!