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 / hrishi
select order_no,count(item_id) from client_order
group by order_no having count(item_id)>3
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Why we use bulk collect in oracle?
Name the various constraints used in oracle?
What is a relational database management system?
What is a table index in oracle?
What is the implicit cursor in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is oracle open database communication (odbc)?
What are the different windows events activated at runtime ?
How to turn on or off recycle bin for the session?
What is a user role in oracle?
What are group functions in oracle?
How to connect to the server with user account: sys?
Differentiate between translate and replace?
Please explain compound trigger in oracle?
What to do if the binary spfile is wrong for the default instance?