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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
What is the difference between RBBMS & DBMS?
What is a materialised view?
How to set up autotrace for a user account?
Which is better Oracle or MS SQL? Why?
What is Segment Advisor in Oracle?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to create a stored function in oracle?
What is oracle and what are its different editions?
How to convert characters to times in oracle?
Explain the use of tables option in exp command.
What is the recommended interval at which to run statspack snapshots, and why?
How to put more than 1000 values into an oracle in clause?