移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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? ()

发布日期:2020-04-10

Evaluate these two SQL statements: SELECT last_nam...
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.

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~