Difference between join and a subquery?
Answer Posted / kiran
subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins
Is This Answer Correct ? | 39 Yes | 5 No |
Post New Answer View All Answers
What is the difference between $oracle_base and $oracle_home?
In what script is snap$ created? In what script is the scott/tiger schema created?
How do we get field detail of a table?
What is oracle in java?
what is IDE,DMV in sql server?
How to check the server version in oracle?
How to apply filtering criteria at group level in oracle?
How to select some rows from a table in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to update values on multiple rows in oracle?
What are oracle functions?
What operating systems are supported by oracle database 10g xe?
Whether any commands are used for months calculation? If so, what are they?
What are the different windows events activated at runtime ?
What is an external table?