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
- 5427 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 |
Explain an index segment?
What is Partitions in Table ?
what is the use of composite key constraint?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
Explain oracle instance.
What are the components of Logical database structure of ORACLE database?
What are group functions in oracle?
What is literal?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Oracle General 
