Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33507 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / a.n.v.v.siva kumar
The main difference between join and sub query is :
join is used to retrieve data from two different tables
where as in sub query we can retreive data from one table
using the result of the where condition on another table.
| Is This Answer Correct ? | 8 Yes | 8 No |
Answer / ramakrishna alla
Above one is exact answer that says sub query is used to get data based on unknown condition (example: select the employee's salary where employee salary greater than clerk) here first we find out clerk salary and then based on his salary we find employee's salary according to above query)
join is used to get the data from atleast 2 tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gomolemo kasale
a sub query is a query nested within another query while
join select rows from multiple table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suryakiran
The main usage of subqueries is to retrieve a single record
from that same table or another table.
And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.
We can perform all operations for joins by using subqueries
but it is very complicated.
| Is This Answer Correct ? | 0 Yes | 1 No |
can we pass two out parameters at a time in function?please answer to my question
What is meant by raw datatype?
Youre getting high busy buffer waits - how can you find whats causing it?
How to synchronize 2 schema's objects?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
How to create an initialization parameter file?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Please explan Why static query is more faster than dynamic query ?
How remove data files before opening a database?
What are the differences between number and binary_float in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to define a variable of a specific record type?
Oracle General 
