( 难度：中等)Mysql按照姓名降序排列用哪个语句？A.ORDER BY DESC NAME B.ORDER BY NAME DESC C.ORDER BY NAME ASCD.ORDER BY ASC NAME
( 难度：中等)Mysql按照姓名降序排列用哪个语句？
A.ORDER BY DESC NAME
B.ORDER BY NAME DESC
C.ORDER BY NAME ASC
D.ORDER BY ASC NAME
A.ORDER BY DESC NAME
B.ORDER BY NAME DESC
C.ORDER BY NAME ASC
D.ORDER BY ASC NAME
相关考题：
用途：指定需返回数据的范围语法：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.
已知关系：学生(学号，姓名，年龄)，如果按年龄降序列出所有学生，并且相同年龄的学生按姓名升序排列。则排序子句应该是( )。A．ORDER BY年龄，姓名B．ORDER BY姓名，年龄C．ORDER BY年龄DESC，姓名D．ORDER BY姓名，年龄DESC
MySQL中用DROP语句可删除数据库和数据表，以下哪句是正确的语法?（）A、DROPTABLEtable_name1B、DROPTABLEtable_name1,table_name2C、DROPTABLEIFEXISTStable_name1D、DROPDATABASEDBname1
连接MySQL后选择需要的数据库DB_NAME?以下哪些方法是对的（）A、连接后用USEDB_NAME选择数据库B、连接后用SETDB_NAME选择数据库C、用mysql-hhost-uuser-pDB_NAME连接数据库D、用mysql-hhost-uuser-p-TDB_NAME连接数据库
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
Person p = new Person(“张三”,23);这条语句会调用下列哪个构造方法给属性进行初始化() A.public Person(){}B.public Person(String name,int age) { this.name = name; this.age = age; }C.public Person(int age,String name) { this.age = age; this.name = name; }D.public Person(String name) { this.name = name; }
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
连接MySQL后选择需要的数据库DB_NAME？以下哪些方法是对的（）A、连接后用USEDB_NAME选择数据库B、连接后用SETDB_NAME选择数据库C、用mysql-hhost-uuser-pDB_NAME连接数据库D、用mysql-hhost-uuser-p-TDB_NAME连接数据库
现有学生住处表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;
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.
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.
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.
单选题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?（）ASORT BY age ASC, last_nameBSORT BY age DESC, last_nameCORDER BY age DESC, last_nameDORDER BY age ASC, last_name
多选题连接MySQL后选择需要的数据库DB_NAME？以下哪些方法是对的（）A连接后用USEDB_NAME选择数据库B连接后用SETDB_NAME选择数据库C用mysql-hhost-uuser-pDB_NAME连接数据库D用mysql-hhost-uuser-p-TDB_NAME连接数据库
单选题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?（）ASORT BY age ASC, last_nameBSORT BY age DESC, last_nameCORDER BY age DESC, last_nameDORDER BY age ASC, last_name
单选题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?（）ASORT BY age ASC, last_nameBSORT BY age DESC, last_nameCORDER BY age DESC, last_nameDORDER BY age ASC, last_name
单选题现有学生住处表Student_info，其中包括姓名（stu_name），学号（stu_id），成绩（stu_grade）。我们需要查询成绩为80分的学生姓名，要求结果按照学号降序排列。下面查询语句正确的是（）。ASELECT stu_name FROM student_info Where stu_grade=80 ORDER BY stu_id ASC;BSELECT stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_id DESC;CSELECT stu_id,stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_name ASC;DSELECT stu_name FROM student_info WHERE stu_grade LIKE 80 ORDER BY stu_id DESC;
单选题关于查询中列的别名, 以下（）语句是不正确的ASelect name as’姓名’from tableBSelect name as姓名from table where id=1CSleect name=姓名from table姓名=names（正确答案）DSelect names姓名from table
单选题关于查询中列的别名, 以下（）语句是不正确的ASelect name as’姓名’from tableBSelect name as姓名from table where id=1CSleect name=姓名from table姓名=names（正确答案）DSelect names姓名from table
多选题连接MySQL后选择需要的数据库DB_NAME？以下哪些方法是对的（）A连接后用USEDB_NAME选择数据库B连接后用SETDB_NAME选择数据库C用mysql-hhost-uuser-pDB_NAME连接数据库D用mysql-hhost-uuser-p-TDB_NAME连接数据库
单选题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?（）ASORT BY age ASC, last_nameBSORT BY age DESC, last_nameCORDER BY age DESC, last_nameDORDER BY age ASC, last_name
多选题连接MySQL后选择需要的数据库DB_NAME？以下哪些方法是对的（）A连接后用USEDB_NAME选择数据库B连接后用SETDB_NAME选择数据库C用mysql-hhost-uuser-pDB_NAME连接数据库D用mysql-hhost-uuser-p-TDB_NAME连接数据库