Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32888 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh
Join:
It is the machanism of joining one or more tables together
and finding information from one or all tables used in join.
Sub Query:
It is a method of finding answer using another query as
parametere for first query.
Main Difference:
In join both the tables should have a comman column type
but in subquery without having a column type we can execute
the query.
| Is This Answer Correct ? | 17 Yes | 16 No |
Post New Answer View All Answers
How to run create database statement?
What are the different types of record groups in oracle? Explain each of them
How to start your 10g xe server from command line?
What is a nvl function?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are the general rules on data consistency?
How do I know if oracle is installed on windows?
How to generate query output in html format?
What is the maximum limit on the number of columns in a table?
Hi Can any one tell me what are the API's used in requisition import.
what is port in oracle? how is it related to database application.
How to manage transaction isolation level?
What is the difference between truncate & delete command?
Describe varray?
How to define a variable of a specific record type?
