Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33069 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
what is meant by magic query
Differentiate between pre-select and pre-query?
what is a Nested Loop join?
What is the oracle implicit cursor?
Explain the use of compress option in exp command.
How many types of segments in Oracle?
How to use "in" parameter properly?
What is a user role in oracle?
What is the difference between post-database commit and post-form commit?
How many data types are supported?
What is an index associated with a constraint?
What is analyze command used for?
Explain temporal data types in oracle
What is Reduced List of Values?
Why should I use oracle database?
