从Student表检索姓周的学生,对应的SQL语句是()。
A、Select * From Student Where Sname like '周%'
B、Select * From Student Where Sname like '%周'
C、Select * From Student Where Sname like '_周'
D、Select * From Student Where Sname like '周_'
A、Select * From Student Where Sname like '周%'
B、Select * From Student Where Sname like '%周'
C、Select * From Student Where Sname like '_周'
D、Select * From Student Where Sname like '周_'
Course 课程表 (编号,课程名称)
Sc 选课表 (学号,课程编号,成绩)
表结构如下:
(1).写一个SQL语句,查询选修了’计算机原理’的学生学号和姓名
(2).写一个SQL语句,查询’周星驰’同学选修了的课程名字
(3).写一个SQL语句,查询选修了5门课程的学生学号和姓名
A、宗法制
B、分封制
C、礼乐制
D、郡县制
A、Select * From Student Order by Smajor DESC , Sage ASC
B、Select * From Student Order by Smajor, Sage DESC
C、Select * From Student Order by Smajor, Sage ASC
D、Select * From Student Order by Smajor ASC, Sage
A、Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno
B、Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.Sno
C、Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.Sno
D、Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
A、Select * from Student where Sno = (Select Sno from SC where Grade >90)
B、Select * from Student where Sno In (Select Sno from SC where Grade >90)
C、Select * from Student where Sno Not In (Select Sno from SC where Grade >90)
D、Select * from Student where Sno Exists (Select Sno from SC where Grade >90)
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!