Oracle
1Z0-082 · Question #70
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
The correct answer is B. Only column names from the first SELECT statement in the compound query are recognized E. Each SELECT statement in the compound query can have its own ORDER BY clause. You've hit your weekly limit · resets 5am (America/New_York)
SQL and PL/SQL
Question
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
Options
- AColumn positions must be used in the ORDER BY clause
- BOnly column names from the first SELECT statement in the compound query are recognized
- CThe first column in the first SELECT of the compound query with the UNION operator is used by
- DEach SELECT statement in the compound query must have its own ORDER BY clause
- EEach SELECT statement in the compound query can have its own ORDER BY clause
How the community answered
(21 responses)- A14% (3)
- B71% (15)
- C5% (1)
- D10% (2)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#ORDER BY#UNION operator#compound query#set operator column reference
Community Discussion
No community discussion yet for this question.