有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是SELECT sna
有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是
SELECT sname,age FROM student
WHERE age【 】;
有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是
SELECT sname,age FROM student
WHERE age【 】;
A. select sname,age from xsb where age>20and age<23B. select*from xsb where age between20 and 23C. select sname,age from xsb where agebetween20 and 23
A、Select * From Student Where Ssex='男' Or Sage<'21'<br> B、Select * From Student Where Ssex='男' Or Sage<21<br> C、Select * From Student Where Ssex=男 And Sage<'21'<br> D、Select * From Student Where Ssex='男' And Sage<21<br>
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 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)
A、Select Tprot,COUNT(*) from Teacher Order by Tprot
B、Select Tprot,COUNT(*) from Teacher Group by Tprot
C、Select Tprot,SUM(*) from Teacher Group by Tprot
D、Select Tprot,SUM(Tprot) from Teacher Group by Tprot
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!