Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 5430 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Does rowid change in oracle?
What is the function of Optimizer ?
How to assign values to variables?
Is oracle a programming language?
WHAT IS ecc 6.0
What are set operators?
What are oracle functions?
What is a data segment ?
Explain oracle insert into command?
What is an oracle cursor variable?
What is a sub query? What are its various types?
How to call a sub procedure?
Oracle General 
