23. Display the client name for all clients who have placed
an order where any order line has more than 3 items. Do not
use a table join anywhere in your query.
Answer Posted / rharshad
select client_name,count(item) from clients where item in
(select Item from items )
having count(item)>3
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is oracle latest version?
What is an oracle user account?
What is Java Pool in Oracle?
What is Library Cache in Oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is data type in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to connect asp pages to oracle servers?
How do I spool in oracle?
What is the oracle implicit cursor?
What is a snapshot in oracle database?
What is a user account in oracle?
How to use subqueries in the from clause in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to get a list of all background sessions in the database?