按照姓名降序排列( )
A.ORDER BY DESC NAME
B.ORDER BY NAME DESC
C.ORDER BY NAME ASC
D.ORDER BY ASC NAME
第1题:
用途:
指定需返回数据的范围
语法:
SELECT column_name FROM table_name
WHERE column_name
BETWEEN value1 AND value2
Order by
用途:
指定结果集的排序
语法:
SELECT column-name(s)FROM table-name ORDER BY{order_by_expression[ASC|DESC
13.
第2题:
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.
第3题:
A. INSTANCE_NAME
B. DB_NAME
C. DB_UNIQUE_NAME
D. SERVICE_NAMES
E. GLOBAL_NAMES
第4题:
Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES 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.
第5题:
已知关系:学生(学号,姓名,年龄),如果按年龄降序列出所有学生,并且相同年龄的学生按姓名升序排列。则排序子句应该是( )。
A.ORDER BY年龄,姓名
B.ORDER BY姓名,年龄
C.ORDER BY年龄DESC,姓名
D.ORDER BY姓名,年龄DESC
第6题:
用print()函数打印输出姓名的名,即姓名中第一个汉字之后的所有汉字(不考虑复姓的情况更),姓名存储在name中,以下方法正确的是:
A.format(name[0])
B.format(name[1])
C.format(name[1:])
D.format(name)