Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33508 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to convert numbers to characters in oracle?
How does Oracle guarantee data integrity of data changes?
What are named parameters?
What do you mean by merge in oracle and how can you merge two tables?
Explain an exception and its types?
How can we force the database to use the user specified rollback segment?
what is reindexing?
How to calculate date and time differences in oracle?
What is the difference between sharding and replication?
What is the usage of analyze command in oracle?
What does sharding mean?
What is a connect identifier?
How to convert characters to times in oracle?
How to convert times to characters in oracle?
What is bulk copy or bcp in oracle?
