A.Like"王"
B.IJike"王 * "
C.王
D.王 *
A.Like"王"
B.IJike"王 * "
C.王
D.王 *
A、有2人以上不及格课程的同学的学号
B、有2门以上及格课程的同学的学号
C、其它选项的说法都不正确
D、有2门以上不及格课程的同学的学号
A、Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname ='计算机');
B、Update Salary= Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = '计算机';
C、Update TABLE Teacher Set Salary = Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = '计算机';
D、Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname='计算机');
A、SELECT S# FROM SC WHERE C#='C2' AND GRADE >=MAX(SELECT GRADE FROM SCWHERE C#='C2');
B、SELECT S# FROM SC WHERE C#='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE C#='C2');
C、SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2');
D、SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SCWHERE C#='C2');
A、CREATE VIEW S_AVG(学号,平均分) AS SELECT 学号,AVG(分数) FROM score WHERE 分数IS NOT NULL GROUP BY 学号;
B、CREATE VIEW S_FEMALE(姓名,出生日期) AS SELECT 姓名,出生日期 FROM student WHERE 性别='女';
C、CREATE VIEW S_MALE(学号,姓名) AS SELECT 学号,姓名 FROM student WHERE 班号='09031';
D、CREATE VIEW S_G(学号,姓名,课程名,分数) AS SELECT S.学号,姓名,课程名,分数 FROM S, SC, C WHERE S.学号=SC. 学号AND SC. 课程号 = C. 课程号;
A、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade DESC;
B、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 and COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC;
C、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade;
D、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC;
A、从职工表中删除行(‘025’,‘王芳’,‘03’,1720)
B、将行(‘005’,‘乔兴’,‘04’,1750)插入到职工表中
C、将职工号为‘001’的工资改为1700
D、将职工号为’038’的姓名改为‘李欣’
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!