单选题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

题目

单选题

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?（）

The two statements produce identical results.

The second statement returns a syntax error.

There is no need to specify DESC because the results are sorted in descending order by default.

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

多选题Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);CSELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);DSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);ESELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

点击查看答案
相关问题 2：

单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）A All of the desired resultsB Two of the desired resultsC One of the desired resultsD An error statement

点击查看答案
相关问题 3：

单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）A All of the desired resultsB Two of the desired resultsC One of the desired resultsD An error statement

点击查看答案
相关问题 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：

单选题Evaluate these two SQL statements: What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

点击查看答案
相关问题 6：

单选题下面哪条语句可以取出薪水最高的前三个人：（）A SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；B SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；C SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；D SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；

点击查看答案
相关问题 7：

多选题Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

点击查看答案

1Z0-007

单选题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

题目

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容