Which three statements are true regarding subqueries? (Choose three.)
A.
Subqueries can contain GROUP BY and ORDER BY clauses.
B.
Main query and subquery can get data from different tables.
C.
Main query and subquery must get data from the same tables.
D.
Subqueries can contain ORDER BY but not the GROUP BY clause.
E.
Only one column or expression can be compared between the main query and subquery.
F.
Multiple columns or expressions can be compared between the main query and subquery.
ABF
Hello,
if i try to execute this query:
select *
from customer_id_equip_map
where subscr_no in (select subscr_no
from service
order by subscr_no)
oracle give me an error: ORA-00907: parentesi chiusa mancante
We came across a cool site that you simply could get pleasure from. Take a look when you want.
Subquery cannot contain order by clause
Sub-queries can’t contain GROUP BY and ORDER BY clauses.