Whatz the main diff between Subquery and a Join
Answer Posted / pardeep chadha
Majorly subqueries run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.
| Is This Answer Correct ? | 32 Yes | 11 No |
Post New Answer View All Answers
What are transaction isolation levels supported by oracle?
What is a sub query and what are the different types of subqueries?
Explain the use of compress option in exp command.
What are the attributes of cursor?
What is tns service name?
Explain the use of show option in imp command.
How to estimate disk space needed for an export job?
Explain mutating triggers.
Describe an oracle table?
candidate key is subset of super key but not vice-verse explain
What is a dead lock in oracle?
What is oracle used for?
How to test null values?
How to enter a new row into a table interactively?
How do you store pictures in a database?