Given the following query:SELECT last_name, first_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_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name

相关考题

单项选择题 Given the following function: CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (A00, B00); END How can this function be used in an SQL statement?

单项选择题 Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）

单项选择题 Which of the following is NOT true about XML columns?（）

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064

IBM(000-730)