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
- 5534 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is MTTR advisor in Oracle?
How to convert characters to dates in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
Difference between cartesian join and cross join?
How to load data from external tables to regular tables?
What are the parameters that we can pass through a stored procedure?
What are the uses of synonyms?
What are the execution control statements in oracle?
How do you store pictures in a database?
What is meant by recursive hints in oracle?
Explain oracle’s server parameter file.
How to insert a new row into a table in oracle?
How to select some columns from a table in oracle?
How to use fetch statement in a loop?
What is Redo Log Buffer in Oracle?
