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
- 5269 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
Can you drop an index associated with a unique or primary key constraint?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
In what script is snap$ created? In what script is the scott/tiger schema created?
What do you mean by cdb and pdb in oracle 12c?
What is using clause and give example?
Explain the use of grant option in imp command.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Why should I use oracle database?
Difference between cartesian join and cross join?
Are truncate and delete commands same? If so why?
What is a trace file and how is it created in oracle?
What is recovery manager in Oracle?
definition of cluster and non-clustered index?
What is the implicit cursor in oracle?
