OCP-1Z0-051 第64题 order by使用别名注意事项

hello_holly

于 2014-05-07 11:14:37 发布

阅读量6.7k

点赞数

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 ORDER BY 别名数字 11g

本文链接：https://blog.csdn.net/holly2008/article/details/25082671

版权

本文探讨了在Oracle SQL查询中使用ORDER BY子句与列别名时的注意事项。通过示例展示了当别名引用不正确时会导致查询失败，而使用数字索引可以正确执行排序。重点讲解了ORDER BY在处理别名时需完全匹配，包括双引号的使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、原题

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.

Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"
FROM promotions ORDER BY code;
SQL>SELECT DISTINCT promo_category promo_cost "code"
FROM promotions ORDER BY 1;
Which statement is true regarding the execution of the above queries?
A. Only the first query executes successfully.
B. Only the second query executes successfully.
C. Both queries execute successfully but

最低0.47元/天解锁文章