Whatz the main diff between Subquery and a Join
- 14 Answers
- 29108 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / mythili
Join:
It is the method of joining one or more tables together and
finding a answer.
Sub Query:
It is a method of finding one answer using another query.
Main Difference:
In join both the tables should have a comman column name
but in subquery without having a column name we can execute
the query.
| Is This Answer Correct ? | 30 Yes | 19 No |
Post New Answer View All Answers
What do you understand by database schema and what does it hold?
What is the difference between primary key and unique key and foreign key in oracle?
How to create a new oracle data file?
How does one get the view definition of fixed views/tables?
What are data pump export and import modes?
How to install oracle odbc drivers?
How to define a record variable to store a table row?
How to use "for" statements in oracle?
How to count duplicated values in a column in oracle?
What is the Tune Query
What is hash cluster in oracle?
What is columnar storage what is the advantage?
What is set operator oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How to use like conditions in oracle?
