网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
按照姓名升序排列（）。
- A、ORDER BY DESC NAME
- B、ORDER BY NAME DESC
- C、ORDER BY ASC NAME
- D、ORDER BY NAME ASC
参考答案
更多 “按照姓名升序排列（）。A、ORDER BY DESC NAMEB、ORDER BY NAME DESCC、ORDER BY ASC NAMED、ORDER BY NAME ASC” 相关考题
考题
设有学生表S(学号,姓名,性别,年龄)，查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS，正确的SQL命令是______。A．SELECT * FROM S WHERE 性别='女' AND 年龄＜=18 ORDER BY 4 DESC INTO TABLE WSB．SELECT * FROM S WHERE 性别='女' AND 年龄＜=18 ORDER BY 年龄 INTO TABLE WSC．SELECT * FROM S WHERE 性别='女' AND 年龄＜=18 ORDER BY '年龄' DESC INTO TABLE WSD．SELECT * FROM S WHERE 性别='女' OR 年龄＜=18 ORDER BY '年龄' ASC INTO TABLE WS
考题
设有学生表 S( 学号 , 姓名 , 性别 , 年龄 ) ，查询所有年龄小于等于 18 岁的女同学，并按年龄进行降序排序生成新的表 WS ，正确的 SQL 命令是A) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 =18 ORDER BY 4 DESC INTO TABLE WSB) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 =18 ORDER BY 年龄 INTO TABLE WSC) SELECT * FROM S WHERE 性别 =' 女 ' AND 年龄 =18 ORDER BY ' 年龄 ' DESC INTO TABLE WSD) SELECT * FROM S WHERE 性别 =' 女 ' OR 年龄 =18 ORDER BY ' 年龄 ' ASC INTO TABLE WS
考题
关系模式SCS(Sno，Cno，Score)中，Sno是学生学号，Cno是课程号，Score是成绩。若要查询每门课成绩的平均成绩，且要求查询结果按平均成绩升序排列，平均成绩相同时，按课程号降序排列，可用SQL语言写为(33)。若查询结果仅限于平均分数超过85分的，则应(34)。(51)A．SELECT Cno，AVG(Score)FROM SCS GROUP BY Score ORDER BY 2.Cno DESCB．SELECT Cno，AVG(Score) FROM SCS GROUP BY Cno ORDER BY 2.Cno DESCC．SELECT Cno，AVG(Score) FROM SCS ORDER BY Cno DESC ORDER BY ScoreD．SELECT Cno，AVG(Score) FROM SCS GROUP BY AVG(Score)ORDER BY Cno DESC
考题
The consignment will be sent()to reach the final destination by the end of May.
A、asB、so asC、dulyD、in order
考题
用途：指定需返回数据的范围语法：SELECT column_name FROM table_nameWHERE column_nameBETWEEN value1 AND value2Order by用途：指定结果集的排序语法：SELECT column-name(s)FROM table-name ORDER BY{order_by_expression[ASC|DESC13.
考题
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
考题
The STUDENT_GRADES table has these columns:The register has requested a report listing the students‘ grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
考题
欲将表“学生”中的信息先按学号升序排序，再按平均成绩升序排列，其正确命令是(45)。A．SELECT * FROM 学生 ORDER BY 学号 ASC，平均成绩 ASCB．SELECT * FROM 学生 ORDER BY 平均成绩 ASC，学号 ASCC．SELECT * FROM 学生 ORDER BY 学号 DESC，平均成绩 DESCD．SELECT * FROM 学生 ORDER BY 平均成绩 DESC，学号 DESC
考题
下面 3～6 题使用如下的“外汇名”表和“持有数”表：第 3 题 查询持有外币种类在4种以上人员的姓名，及持有的种类数量，并按种类数量升序排列，数量相同时，则按姓名降序排列，下列语句正确的是（ ）。A)SELECT姓名，COUNT(﹡)AS外币种类FROM持有数；GROUP BY姓名HAVING COUNT(﹡)=4；ORDER BY外币种类，姓名DESCB)SELECT姓名，COUNT(﹡)AS外币种类FROM持有数；GROUP BY姓名HAVING COUNT(﹡)=4；ORDER BY COUNT(﹡)，姓名DESCC)SELECT姓名，COUNT(﹡)AS外币种类FROM持有数；GROUP BY姓名HAVING COUNT(﹡)=4；ORDERBY外币种类AND姓名DESCD)SELECT姓名，COUNT(﹡)AS外币种类FROM持有数；GROUP BY姓名HAVING COUNT(﹡)=4：ORDER BY外币种类+姓名DESC
考题
已知关系：学生(学号，姓名，年龄)，如果按年龄降序列出所有学生，并且相同年龄的学生按姓名升序排列。则排序子句应该是( )。A．ORDER BY年龄，姓名B．ORDER BY姓名，年龄C．ORDER BY年龄DESC，姓名D．ORDER BY姓名，年龄DESC
考题
查询持有外币种类在4种以上人员的姓名及持有的种类数量，并按种类数量升序排列，数量相同时，则按姓名降序排列，下列语句正确的是（ ）。A.SELECT姓名，COUNT(*)AS外币种类FROM持 有数 GROUP BY姓名HAVING COUNT(*)=4ORDER BY外币种类，姓名DESCB.SELECT姓名，COUNT(*)AS外币种类FROM持 有数 GROUP BY姓名HAVING COUNT(*)V40RDER BY COUNT(*)，姓名DESCC.SELECT姓名，cUNT(*)AS外币种类FROM持 有数 GROUP BY姓名HAVING COUNT(*)=4ORDER BY外币种类AND姓名DESCD.SELECT姓名，COUNT(*)AS外币种类FROM持 有数 GROUP BY姓名HAVING COUNT(*)=4 ORDER BY外币种类+姓名DESC
考题
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age >40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A.SORT BY age ASC, last_nameB.SORT BY age DESC, last_nameC.ORDER BY age DESC, last_nameD.ORDER BY age ASC, last_name
考题
查询持有外币种类在4种以上人员的姓名，及持有的种类数量，并按种类数量升序排列，数量相同时，则按姓名降序排列，下列语句正确的是( )。A．SELECT 姓名,COUNT(*) AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT(*)＞=4; ORDER BY 外币种类,姓名 DESCB．SELECT 姓名,COUNT(*) AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT(*)＞=4; ORDER BY COUNT(*),姓名 DESCC．SELECT 姓名,COUNT(*) AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT(*)＞=4; ORDER BY 外币种类 AND 姓名 DESCD．SELECT 姓名,COUNT(*) AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT(*)＞=4; ORDER BY 外币种类+姓名 DESC
考题
在Hibernate的Criteria查询中，下列按创建日期进行排序的方法是（）。A、criteria.addOrder（Order.asc（"createDate"））；B、criteria.addOrder（Order.desc（"createDate"））；C、criteria.saveOrder（Order.asc（"createDate"））；D、criteria.saveOrder（Order.desc（"createDate"））；
考题
在GZ表中选出职称为“工程师”的记录，并按年龄的降序排列，则实现的SQL语句为（）A、SELECT FROM GZ for 职称=工程师 ORDER BY 年龄/DB、SELECT FROM GZ WHERE职称=工程师 ORDER BY 年龄 DESCC、SELECT * FROM GZ WHERE职称=‟工程师‟ ORDER BY 年龄 DESCD、SELECT * FROM GZ WHERE职称=‟工程师‟ ORDER ON 年龄 DESC
考题
查询员工工资信息时，结果按工资降序排列，正确的是（）。A、ORDER BY 工资B、ORDER BY 工资 descC、ORDER BY 工资 ascD、ORDER BY 工资 dictinct
考题
现有学生住处表Student_info，其中包括姓名（stu_name），学号（stu_id），成绩（stu_grade）。我们需要查询成绩为80分的学生姓名，要求结果按照学号降序排列。下面查询语句正确的是（）。A、SELECT stu_name FROM student_info Where stu_grade=80 ORDER BY stu_id ASC;B、SELECT stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_id DESC;C、SELECT stu_id,stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_name ASC;D、SELECT stu_name FROM student_info WHERE stu_grade LIKE 80 ORDER BY stu_id DESC;
考题
在查询结果输出时要求按总评成绩降序，相同者按性别升序，下列正确的子句是（）。A、ORDER BY总评成线、性别DESCB、ORDER BY总评成线DESC、性别C、ORDER BY总评成线DESC、性别DESCD、ORDER BY总评成线ASC、性别DESC
考题
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
考题
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）A
The two statements produce identical results.B
The second statement returns a syntax error.C
There is no need to specify DESC because the results are sorted in descending order by default.D
The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
考题
单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;C
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;D
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;E
SELECT student_id, semester_end, gpa FROM student_grades
考题
单选题按照姓名升序排列（）。A
ORDER BY DESC NAMEB
ORDER BY NAME DESCC
ORDER BY ASC NAMED
ORDER BY NAME ASC
考题
( 难度：中等)Mysql按照姓名降序排列用哪个语句？A.ORDER BY DESC NAME B.ORDER BY NAME DESC C.ORDER BY NAME ASCD.ORDER BY ASC NAME
热门标签
最新试卷