Difference between join and a subquery?
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
How to create id with auto_increment on oracle?
What is Reduced List of Values?
How to view the data files in the current database?
How to use windows user to connect to the server?
what is Single Byte Overhead...?
What is the string concatenation operator in oracle?
Explain the use of tables option in exp command.
What is a read write transaction in oracle?
What is the scope of a local variable?
What is a package ? What are the advantages of package ?
How to create a table interactively?
What is bulk collect in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
Give the various rollback segment states.
Can you have more than one content canvas view attached with a window ?