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
- 5304 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 |
What are the basic element of Base configuration of an oracle Database ?
How to use existing values in update statements using oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What privilege is needed for a user to delete rows from tables in another schema?
What is RULE-based approach to optimization ?
How are Indexes Update ?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Can we create trigger on view in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain what are the different type of segments?
How to do paging with oracle?
Oracle General 
