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
- 5362 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 diffrence between function and procedure?
What is meant by recursive hints in oracle?
What is open database communication (odbc) in oracle?
How to change program global area (pga) in oracle?
which language is used to develop the oracle........?
What is an Oracle Instance?
What do you understand by a database object?
What is an oracle wallet?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How do I know if oracle is installed on windows?
What happens to the current transaction if a ddl statement is executed?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
Oracle General 
