请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。选项： A:Select * From Student Where Ssex='男' And Sage<21; B:Select * From Student Where Ssex='男' Or Sage<'21'; C:Select * From Student Where Ssex='男' Or Sage<21; D:Select * From Student Where Ssex=男 And Sage<'21'
- 2.从Student表检索年龄小于21岁的男学生信息,最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage B、Select * From Student Where Ssex='男' And Sage<21 C、Select * From Student Where Ssex=男 And Sage D、Select * From Student Where Ssex='男' Or Sage<21
- 3.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage'21' B、Select * From Student Where Ssex='男' Or Sage21 C、Select * From Student Where Ssex=男 And Sage'21' D、Select * From Student Where Ssex='男' And Sage21
- 4.从Student表检索年龄小于21岁的男学生信息,最规范的SQL语句是( )。A.Select * From Student Where Ssex='男' And Sage
- 5.查询表student（sno,sname,sage,ssex,sphone,cno）中男生的相关信息的SQL语句为（ ）选项： A:select * from student where ssex='男' ; B:select sno,sname,sage,ssex,sphone,cno from student order by ssex='男' ; C:select sno,sname,sage,ssex,sphone,cno from student having ssex='男' ; D: SELECT* FROM student Group By ssex='男‘
- 6.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间（包括17和25）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:Select * From Student Where Sage between 17 and 25; B:Select Sname, Sage From Student Where Sage between 17 and 25; C:Select Sname, Sage From Student Where Sage >= 17 and Sage<= 25; D:Select Sname, Sage From Student Where Sage >= 17 or Sage<= 25
- 7.从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。选项： A:Select * From Student where Sage=20; B:Select * From Student where Sage='20'; C:Select * From Student where Sage=【20】; D:Select * From Student where Sage EQUAL 20
- 8.从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。 选项： A、Select * From Student where Sage=20 B、Select * From Student where Sage='20' C、Select * From Student where Sage=【20】 D、Select * From Student where Sage EQUAL 20
- 9.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间（包括17和25）的学生的姓名及年龄，SQL语句正确的是（ ）。 选项： A、Select * From Student Where Sage between 17 and 25 B、Select Sname, Sage From Student Where Sage between 17 and 25 C、Select Sname, Sage From Student Where Sage >= 17 and Sage<= 25 D、Select Sname, Sage From Student Where Sage >= 17 or Sage<= 25
- 10.从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。 选项： A、Select * From Student where Sage=20 B、Select * From Student where Sage='20' C、Select * From Student where Sage=【20】 D、Select * From Student where Sage EQUAL 20
- 11.从Student表检索年龄为20岁的学生信息,已知年龄字段是数值类型,最规范的SQL语句是( )。A．Select * From Student where Sage='20'B．Select * From Student where Sage=20C．Select * From Student where Sage EQUAL 20D．Select * From Student where Sage=【20】
- 12.有学生表Student(S# char(8), Sname char(10), Ssex char(2), Sage integer, D# char(2), Sclass char(6))。要检索学生表中“所有年龄小于等于19岁的学生的年龄及姓名”，SQL语句正确的是_________。? Select Sage, Sname From Student Where Sage <= 19;Select * From Student Where Sage <= 19;Select Sname From Student Where Sage <= 19;Select Sage, Sname From; Student;
- 13.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:Select * From Student Where Sage between 16 and 30; B:Select Sname, Sage From Student Where Sage between 16 and 30; C:Select Sname, Sage From Student Where Sage >= 16and Sage<= 30; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30
- 14.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30; B:Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; C:Select * From Student Where Sage between 16 and 30; D:Select Sname, Sage From Student Where Sage between 16 and 30
- 15.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; B:select Sname, Sage From Student Where Sage >= 16 or Sage<= 30; C:select * From Student Where Sage between 16 and 30; D:select Sname, Sage From Student Where Sage between 16 and 30
- 16.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:Select Sname, Sage From Student Where Sage between 16 and 30;; B:Select Sname, Sage From Student Where Sage >= 16and Sage<= 30;; C:Select * From Student Where Sage between 16 and 30;; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30;
- 17.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; B:select Sname, Sage From Student Where Sage >= 16 or Sage<= 30; C:select * From Student Where Sage between 16 and 30; D:select Sname, Sage From Student Where Sage between 16 and 30
- 18.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。 选项： A、Select * From Student Where Sage between 16 and 30 B、 Select Sname, Sage From Student Where Sage between 16 and 30 C、 Select Sname, Sage From Student Where Sage >;= 16 and Sage<;= 30 D、 Select Sname, Sage From Student Where Sage >;= 16 or Sage<;= 30
- 19.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。选项： A:Select * From Student Where Sage between 16 and 30; B:Select Sname, Sage From Student Where Sage between 16 and 30; C:Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30
- 20.有学生表Student(S# char(8), Sname char(10), Ssex char(2), Sage integer, D# char(2), Sclass char(6))。要检索学生表中“所有年龄小于等于19岁的学生的年龄及姓名”，SQL语句正确的是_________。选项： A:Select Sage, Sname From Student Where Sage <= 19;; B:Select Sname From Student Where Sage <= 19;; C:Select * From Student Where Sage <= 19;; D:Select Sage, Sname From Student;
- 21.有学生表Student(S# char(8), Sname char(10), Ssex char(2), Sage integer, D# char(2), Sclass char(6))。要检索学生表中“所有年龄小于等于19岁的学生的年龄及姓名”，SQL语句正确的是_________。 选项： A、Select Sage, Sname From Student Where Sage <= 19; B、Select Sname From Student Where Sage <= 19; C、Select * From Student Where Sage <= 19; D、Select Sage, Sname From Student;
- 22.有学生表Student(S# char(8), Sname char(10), Ssex char(2), Sage integer, D# char(2), Sclass char(6))。要检索学生表中“所有年龄小于等于19岁的学生的年龄及姓名”，SQL语句正确的是（ ）。选项： A:Select * From Student Where Sage <= 19;; B:Select Sage, Sname From Student Where Sage <= 19;; C:Select Sage, Sname From Student;; D:Select Sname From Student Where Sage <= 19;
- 23.【多选题】针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是()。A. Select * From Student Where Sage between 16 and 30B. Select Sname, Sage From Student Where Sage between 16 and 30C. Select Sname, Sage From Student Where Sage >= 16and Sage<= 30D. Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30
- 24.有学生表Student(S# char(8), Sname char(10), Ssex char(2), Sage integer, D# char(2), Sclass char(6))。要检索学生表中“所有年龄小于等于19岁的学生的年龄及姓名”，SQL语句正确的是_________。A.Select Sname From Student Where Sage <= 19;B.Select Sage, Sname From Student Where Sage <= 19;C.Select * From Student Where Sage <= 19;D.Select Sage, Sname From Student;
- 25.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept ; C:select sdept ,avg(sage) from student where ssex='女' group by sdept; D:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20
- 26.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。（3.0分） 选项： A:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 B:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept C:select sdept ,avg(sage) from student where ssex='女' group by sdept D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20
- 27.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。 选项： A、select Sname, Sage From Student Where Sage between 16 and 30 B、Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30 C、Select * From Student Where Sage between 16 and 30 D、Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30
- 28.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。 选项： A、Select Sname, Sage From Student Where Sage between 16 and 30; B、Select Sname, Sage From Student Where Sage >= 16and Sage<= 30; C、Select * From Student Where Sage between 16 and 30; D、Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30;
