Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33905 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh
Join:
It is the machanism of joining one or more tables together
and finding information from one or all tables used in join.
Sub Query:
It is a method of finding answer using another query as
parametere for first query.
Main Difference:
In join both the tables should have a comman column type
but in subquery without having a column type we can execute
the query.
| Is This Answer Correct ? | 17 Yes | 16 No |
Post New Answer View All Answers
Is it possible to split the print reviewer into more than one region ?
What are the ways tablespaces can be managed and how do they differ?
How to list all user accounts in oracle?
What is columnar storage what is the advantage?
What is BBED in Oracle?
How to empty your oracle recycle bin?
how to handle exceptions in post production
How would you go about verifying the network name that the local_listener is currently using?
What do you mean by merge in oracle and how can we merge two tables?
What is the order of defining local variables and sub procedures/functions?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to assign values to variables?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How different is ms access and oracle?
How to work with data objects interactively?
