Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45345 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / kiran
subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins
| Is This Answer Correct ? | 39 Yes | 5 No |
Post New Answer View All Answers
What is a server parameter file in oracle?
what is the scenario where you take the database to NoArchivelog mode?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Is the After report trigger fired if the report execution fails ?
what is the difference between restoring and recovering?
How can we find out the duplicate values in an oracle table?
How to select an oracle system id (sid)?
Explain mutating triggers.
Explain an index?
What is user managed backup in Oracle?
Explain the use of inctype option in exp command.
What is a tns service name?
List the types of joins used in writing subqueries?
What are joins, explain all types of joins?
Explain the use of log option in exp command.
