Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45073 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
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
How many types of database triggers exist?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
what happened to the global index when I truncate the data in one of the partition?
How many memory layers are in the oracle shared pool?
How to load excel data sheet to oracle database
What is blob datatype?
How to create a table interactively?
How to fetch the row which has the max value for a column?
what is difference between sql plus and sql*plus? (not sql and sql plus).
query optmization techniques and quwry analyser+projects+ppts
What is the order of defining local variables and sub procedures/functions?
How to use "for" statements in oracle?
How to define default values for formal parameters?
How to retrieve data from an cursor to a record?
What is archive log in Oracle?
