请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 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.从学生表显示所有学生的信息，按照专业的升序排列，专业相同再按照年龄的降序( )。 选项： 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
- 4.针对学生表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
- 5. 针对学生表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;
- 6.针对学生表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
- 7.针对学生表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
- 8.从学生表查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ） 选项： 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
- 9.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ） 选项： 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 , sage descB．select * from student order by sdept , sageC．select * from student order by sdept desc, sageD．select sname, sdept, sage from student order by sdept desc , sage
- 11.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排列。（ ）选项： 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
- 12.【单选题】针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。()A. select * from student order by sdept , sageB. select sname, sdept, sage from student order by sdept , sage descC. select sname, sdept, sage from student order by sdept desc , sageD. select * from student order by sdept desc, sage
- 13.单选题 （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
-
14.查询学生的姓名，系别和年龄，显示时按系别降序排列，系别相同的再按年龄升序排 列。( ) 选项： 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
- 15.“Select Sno,Sname,Ssex,Sage,Smajor From Student”检索语句中，用来分隔开字段名的逗号，需要是纯英文的逗号，不能是中文逗号
- 16.“Select Sno,Sname,Ssex,Sage,Smajor From Student”检索语句中，用来分隔开字段名的逗号，需要是纯英文的逗号，不能是中文逗号选项： A:正确; B:错误
- 17.针对学生表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
- 18.针对学生表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
- 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(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
- 21.针对学生表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;
- 22.【多选题】针对学生表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
