Whatz the main diff between Subquery and a Join
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
How to resolve the ORA-39133 error in Oracle?
What privilege is needed for a user to query tables in another schema?
How to select some columns from a table in oracle?
How to pass a cursor variable to a procedure?
How to store pictures on to the database?
How can I introduce multiple conditions in like operator?
How to use group functions in the select clause using oracle?
Which environment variables are absolutely critical in order to run the OUI?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain the use of ignore option in imp command.
How to experiment a data lock in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to define a record variable to store a table row?
What is tns service name?
What are the benefits of ordbms?