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
- 5532 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 a cluster and non-cluster index?
What is partitioned table in Oracle?
How to get a list of all user accounts in the database?
How do I limit the number of oracle database connections generated by weblogic server?
Can we create trigger on materialized view in oracle?
What is proxy method?
Is rowid unique in oracle?
What are the Limitations of a CHECK Constraint ?
what are the diffeenes between oracle 9i,oracle 10g
how many types of index?
How to find the date and time of last updated table?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Oracle General 
