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 / name
select client_name,count(item) from clients where item=
(select Item from items )
having count(item)>3
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can objects of the same schema reside in different tablespace?
What is the quickest way to export a table to a flat file?
What is connection pooling in oracle?
How to loop through a cursor variable?
What privilege is needed for a user to insert rows to tables in another schema?
How to increment dates by 1 in oracle?
Differentiate between function and procedure in oracle.
What language does oracle use?
How to do clean up if create database failed?
Why does Oracle not permit the use of PCTUSED with indexes?
How do I find the database name in oracle?
Explain what are the type of synonyms?
Why cursor variables are easier to use than cursors?
How to start a specific oracle instance?
What are the arithmetic operations?