请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.按照先后顺序依次显示学生表的最大、最小和平均年龄，对应的SQL语句是( )。选项： A:Select MAX, MIN, AVG Sage from Student ; B:Select MIN, MAX, AVG Sage from Student ; C:Select MAX(Sage),MIN(Sage),AVG(Sage) from Student ; D:Select MIN(Sage),MAX(Sage),AVG(Sage) from Student
- 2.按照先后顺序依次显示学生表的最大、最小和平均年龄,对应的SQL语句是() 选项： A、SelectMIN,MAX,AVGSagefromStudent B、SelectMIN(Sage),MAX(Sage),AVG(Sage)fromStudent C、SelectMAX,MIN,AVGSagefromStudent D、SelectMAX(Sage),MIN(Sage),AVG(Sage)fromStudent
- 3.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。（ ）选项： A:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >2; B:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; 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
- 4.针对表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
- 5.针对表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
- 6.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept ; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20; 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
- 7.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。 选项： A、select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept B、select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 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
- 8.针对表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='女' group by sdept C、select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 D、select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept
- 9.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >2; 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
- 10.单选题]针对表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='女' group by sdept C:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 D:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept
- 11.从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
-
12.有如下SQL
SELECT语句:SELECT*
FROM Student WHERE Sage BETWEEN 18 AND 20,与该语句等价的是() 选项： A、SELECT
* FROM Student WHERE Sage=20 B、SELECT
* FROM Student WHERE Sage20 C、SELECT
* FROM Student WHERE Sage>=18.ANSage D、SELECT
* FROM Student WHERE Sage>18.ANSage - 13.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 A: Select * From Student Where Ssex='男' Or Sage<'21' B: Select * From Student Where Ssex='男' Or Sage<21 C: Select * From Student Where Ssex=男 And Sage<'21' D: Select * From Student Where Ssex='男' And Sage<21
- 14.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage<'21' B、Select * From Student Where Ssex='男' Or Sage<21 C、Select * From Student Where Ssex=男 And Sage<'21' D、Select * From Student Where Ssex='男' And Sage<21
- 15.从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'
- 16.从学生表查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ） 选项： A、select * from student order by sdept , sage B、select sname, sdept, sage from student order by sdept , sage C、select sname, sdept, sage from student order by sdept desc , sage D、select * from student order by sdept desc, sage
- 17.使用教学（STC）数据库，与如下查询语句等价的是（ ）。 SELECT *FROM Student WHERE Sdept = 'CS' EXCEPT SELECT * FROM Student WHERE Sage <= 19; 选项： A、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19 B、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19 C、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19 D、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19
- 18.SELECT Sname，Sdept，Sage FROM Student WHERE Sage BETWEEN 20 AND 23等同于语句SELECT Sname，Sdept，Sage FROM Student WHERE Sage >20 and sage< 23
- 19.从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】
- 20.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ） 选项： A、select * from student order by sdept , sage B、select sname, sdept, sage from student order by sdept , sage C、select sname, sdept, sage from student order by sdept desc , sage D、select * from student order by sdept desc, sage
