Which three statements are true about multiple-row sub queries? (Choose three.)
A. They can contain a subquery within a sub query.
B. They can return multiple columns as well as rows.
C. They cannot contain a sub query within a sub query.
D. They can return only one column but multiple rows.
E. They can contain group functions and GROUP BY and HAVING clauses.
F. They can contain group functions and the GROUP BY clause, but not the HAVING clause.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
F may be correct.
This is an example of perfect sub-query that contains HAVING clause
select * from employees where department_id IN
( select department_id from (
select department_id, count(*) counter from departments group by department_id having department_id > 20)) ;
sorry I wanted to say F is incorrect because HAVING clause is allowed and it is seen in example that I have published above.
ABE correct answers.
Find a query that explains all 3 answers A, B and E
select * from orders where (order_id, promotion_id) IN
( select order_id, promotion_id from (
select order_id, promotion_id , count(*) from orders_direct
group by order_id, promotion_id
having count(*) >=1));