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
- 5360 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 are the tools for Oracle ?
How to select all columns of all rows from a table in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Please explain joins in oracle?
What is execute immediate in oracle?
How to connect ms access to oracle servers?
Explain the use of indexes option in exp command.
how to make an oracle object
How to retrieve data from an cursor to a record?
What is index-organized table in Oracle?
What is the data pump import utility?
What is using clause and give example?
What is the recommended interval at which to run statspack snapshots, and why?
Explain the use of grant option in exp command.
