Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33045 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
How to add a new column to an existing table in oracle?
Can a formula column referred to columns in higher group ?
How to do a full database export?
What is an anonymous block?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is Trigger in Oracle?
What is the difference between 10g OEM and 11g OEM?
How to write a left outer join with the where clause in oracle?
How to start a specific oracle instance?
How to resolve the ORA-39133 error in Oracle?
Explain integrity constraint?
Explain the difference between sap and oracle?
What is a server parameter file in oracle?
How to start instance with a minimal initialization parameter file?
How to drop an existing view in oracle?
