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
- 5421 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 do you mean by a database transaction & what all tcl statements are available in oracle?
How many categories of data types in oracle?
What is the use of aggregate functions in oracle?
How to get execution statistics reports on query statements?
How can you Enforce Referential Integrity in snapshots ?
Explain about functional dependency and its relation with table design?
What is a nvl function? How can it be used?
What is a nested table and how is it different from a normal table?
What are the system predefined user roles?
What are the general rules on data consistency?
What is a static data dictionary in oracle?
What is Database Buffers ?
Oracle General 
