Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33494 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
Explain parameter file in oracle.
How to write numeric literals in oracle?
How to export data with a field delimiter?
How to experiment a data lock in oracle?
What is Redo Log Buffer in Oracle?
How to connect to a remote server?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to get the Installed Oracle Version Information ?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is the string concatenation operator in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to start your 10g xe server from command line?
What are privileges and grants?
What is the data type of dual table?
How to create additional tablespaces for an new database?
