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 privilege is needed for a user to delete rows from tables in another schema?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How can I get column names from a table in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between sharding and partitioning?
Is there any function in oracle similar like group_concat of mysql?
What is index in Oracle?
What is oracle database client?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain rename?
Explain enable novalidate constraint.
How remove data files before opening a database?
What is a sub query? What are its various types?
List out the components of logical database structure of oracle database.
Explain the use of rows option in imp command.