查有成绩的学生信息注意EXISTS关键字 select student.* from student where student.sid in （select DISTINCT sc.sid from sc) select * from student where EXISTS（select * from sc where student.SId=sc.SId)

提问人：网友tianfu200 发布时间：2022-01-07

参考答案

抱歉！暂无答案，正在努力更新中……

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装简答题APP，拍照搜题省时又省心！

更多“查有成绩的学生信息注意EXISTS关键字 select s…”相关的问题

第1题

从学生()字段查找姓“张”的学生可以使用如下代码:select * from student where

A．NAME= ’张*’

B．NAME= ‘%张%’

C．NAME LIKE ‘张%’

D．NAME LIKE ‘张*’

点击查看答案

第2题

在MySQL数据库中，有student(学生)表，包含字段: SID(学号)，SNAME(姓名),Grade(成绩)。现要将所有学员的成绩加10分。下列SQL语句正确的是()。

A、update students set Grade=Grade+10 where SID=1

B、update * set Grade=Grade+10

C、update * from stedents set Grade=Grade+10

D、update students set Grade=Grade+10

点击查看答案

第3题

已知有student表，studentid为主键，现在表中共有10行记录，studentid列值从1到10创建视图:createviewdbo.view_studentasselect*fromdbo.student接着执行如下命令:deletefromview_studentwhere(studentid=8);然后执行查询命令:select*fromstudent;select*fromview_student;假定上述命令全部执行成功，将各自返回()行记录。()

A、9,9

B、9,10

C、10,10

D、10,9

点击查看答案

第4题

从student中查询所有女生信息，存入stufemal中，正确的是（）

A、select * into stufemal from student

B、select * into stufemal from student where ssex='女'

C、select * from student where ssex='女' into stufemal

D、select * from student into stufemal

点击查看答案

第5题

解释SELECT在SQL中的作用？

点击查看答案

第6题

查询没有学全所有课程的同学的信息这种解法不包括什么课都没选的学生 select student.* from student, (select sid, count(cid) as coursecount from sc group by sid) as t1 where student.sid = t1.sid and t1.coursecount<>3 select student.* from sc ,student where sc.SId=student.SId GROUP BY sc.SId Having count(*)<(select count(*) from course) 利用笛卡尔积可以把什么课都没选的同学查询出来 select distinct student.* (select student.sid,course.cid student,course ) as t1 left join sc.sid,sc.cid sc)as t2 on t1.sid="t2.SId" and t1.cid="t2.CId,student" where t2.sid is null student student.sid not in ( sc, sc.sid="student.sid" group by sid having>

点击查看答案

第7题

查询和" 01 "号的同学学习的课程完全相同的其他同学的信息 select DISTINCT student.* from ( select student.SId, t.CId from student ,(select sc.CId from sc where sc.SId='01') as t) as t1 LEFT JOIN sc on t1.SId=sc.SId and t1.CId=sc.CId,student where sc.SId is not null and t1.SId=student.SId and t1.SId <>'01'

点击查看答案

第8题

查询学过「张三」老师授课的同学的信息 select student.* from student, sc where student.sid = sc.sid and sc.cid in (select cid from course, teacher where course.tid = teacher.tid and Tname = '张三') 同时连接多张表 select student.* from teacher ,course ,student, sc where teacher.Tname='张三' and teacher.TId=course.TId and course.CId=sc.CId and sc.SId=student.SId

点击查看答案

第9题

查询至少有一门课与学号为" 01 "的同学所学相同的同学的信息 select DISTINCT student.* from sc, student where sc.CId in ( select CId from sc where SId='01') and sc.SId = student.SId

点击查看答案