Whatz the main diff between Subquery and a Join
- 14 Answers
- 29194 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 primefaces used for?
What are the attributes of the cursor?
How to update a table row with a record?
When do you get a .pll extension in oracle? Explain its importance
What is recycle bin in Oracle?
What is meant by joins? List out the types of joins.
What is catalog in Oracle?
How to delete multiple rows from a table in oracle?
What are the major difference between truncate and delete?
What is the max number of columns in an oracle table?
How to get a list of all background sessions in the database?
How to filter out duplications in the returning rows using oracle?
How to use attributes of the implicit cursor in oracle?
What is the data pump export utility?
How to insert a new row into a table in oracle?
