请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.从学生表显示所有学生的信息，按照专业的升序排列，专业相同再按照年龄的降序( )。选项： A:Select * From Student Order by Smajor, Sage DESC; B:Select * From Student Order by Smajor, Sage ASC; C:Select * From Student Order by Smajor DESC , Sage ASC; D:Select * From Student Order by Smajor ASC, Sage
- 2.从学生表显示所有学生的信息，按照专业的升序排列，专业相同再按照年龄的降序( )。 选项： 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
- 3.设有学生表student（sno，sname，sage，smajor），字段含义分别为学生学号、姓名、年龄、专业。现有语句： SELECT sno，sname，sage，smajor FROM student ORDER BY smajor，sage DESC 执行上述语句，其检索结果（）。 选项： A、按smajor升序、sage降序排列 B、按smajor降序、sage升序排列 C、按smajor及sage的降序排列 D、按smajor及sage的升序排列
- 4.设有学生表student(sno,sname,sage,smajor)，字段含义分别为学生学号、姓名、年龄、专业。现有语句： SELECT sno,sname,sage, smajor FROM student ORDER BY smajor DESC, sage 执行上述语句，其检索结果（ ）。 选项： A、按smajor降序、sage升序排列 B、按smajor升序、sage降序排列 C、按smajor及sage的降序排列 D、按smajor及sage的升序排列
- 5.从学生表查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ） 选项： 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
- 6.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。( ) 选项： 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
- 7.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ）选项： 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
- 8.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ）选项： A:select sname, sdept, sage from student order by sdept desc , sage; B:select * from student order by sdept , sage; C:select sname, sdept, sage from student order by sdept , sage; D:select * from student order by sdept desc, sage
- 9.单选题 （1分）查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。( ) 选项： 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
- 10.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（ ）选项： A:select sname, sdept, sage from student order by sdept desc , sage; B:select * from student order by sdept , sage; C:select sname, sdept, sage from student order by sdept , sage desc; D:select * from student order by sdept desc, sage
- 11.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（ ）选项： A:select * from student order by sdept , sage; B:select sname, sdept, sage from student order by sdept , sage desc; C:select sname, sdept, sage from student order by sdept desc , sage; D:select * from student order by sdept desc, sage
- 12. 针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（ ）选项： A: select sname, sdept, sage from student order by sdept , sage desc;; B: select * 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;
- 13.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（ ）（3.0分） 选项： A:select sname, sdept, sage from student order by sdept , sage desc B:select * 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
- 14.单选题]针对学生表（student(sno,sname,ssex,sage,sdept)），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列，以下哪条语句合适（ ）？ 选项： A:select sname, sdept, sage from student order by sdept, sage desc B:select * from student order by sdept, sage C:select * from student order by sdept desc, sage D:select sname, sdept, sage from student order by sdept desc, sage
- 15.从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： 选项： A、select name, age, score from student order by age desc , score; B、select name, age, score from student order by age , score asc; C、select name, age, score from student order by 2 desc , 3 asc; D、select name, age, score from student order by 1 desc , 2；
- 16.按照先后顺序依次显示学生表的最大、最小和平均年龄，对应的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
- 17.从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
- 18.查询表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='男‘
- 19.从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
- 20.从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
- 21.从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'
