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
- 5407 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 max rowid in oracle?
What exactly do quotation marks around the table name do?
What is merge in oracle?
How to define a specific record type?
How to define and use table alias names in oracle?
Explain an exception and its types?
interview questions with answer for cts
What is the difference between pre-select and pre-query?
Where are the settings stored for each instance in oracle?
Can a parameter be passed to a cursor?
What are named parameters?
What are advantages of dateset in datastage?
Why do we use coalesce function in oracle?
How to create an oracle testing table?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
