Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32894 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / mythili
Join:
It is the method of joining one or more tables together and
finding a answer.
Sub Query:
It is a method of finding one answer using another query.
Main Difference:
In join both the tables should have a comman column name
but in subquery without having a column name we can execute
the query.
| Is This Answer Correct ? | 30 Yes | 19 No |
Post New Answer View All Answers
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to divide query output into groups in oracle?
Explain enable novalidate constraint.
What privilege is needed for a user to delete rows from tables in another schema?
what is the difference between substr and instr function in oracle?
Explain oracle 12c new features for developers?
What privilege is needed for a user to create tables in oracle?
What is oracle thin client?
Why is oracle so popular?
candidate key is subset of super key but not vice-verse explain
Will you be able to store pictures in the database?explain.
What is an oracle data file?
How to update a table row with a record?
What are the four Oracle system processes that must always be up and running for the database to be useable?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
