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
- 5363 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Difference between open_form and call_form in oracle.
How do I learn what codesets are available in oracle?
How to find out what oracle odbc drivers are installed?
what are the default admin accounts in Oracle 10g ?
How to create an oracle testing table?
Explain the different normalization forms?
Can we store images in oracle database?
How to specify default values in insert statement using oracle?
What do you mean by merge in oracle and how can we merge two tables?
How to see the table columns used in an index?
What is open database communication (odbc) in oracle?
How many anonymous blocks can be defined?
How to create a table interactively?
What are named parameters?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
