Which three statements are true regarding subqueries?
A. Multiple columns or expressions can be compared between the main query and subquery.
B. Subqueries can contain ORDER BY but not the GROUP BY clause.
C. Main query and subquery can get data from different tables.
D. Subqueries can contain GROUP BY and ORDER BY clauses.
E. Main query and subquery must get data from the same tables.
F. Only one column or expression can be compared between the main query and subquery.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Subqueries cannot containt ORDER BY
AC is true. Subqueries cannot containt ORDER BY
ACD. SUBQUERIES can have ORDER BY. This is the correct answer (option A) from question 242. Notice both the main and subquery must have the same ORDER BY (order_id):
— find the highest total value among all the orders — both the main and subquery need a GROUP BY
select order_id
from order_items_copy
group by order_id
having sum(unit_price*quantity) = (select max(sum(unit_price*quantity))
from order_items_copy group by order_id);
Also–
select * from (
select *
from hr.employees
order by last_name desc
)