Whatz the main diff between Subquery and a Join

Answer Posted / anbu

their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the components of logical database structure of oracle database.

583


Does facebook use oracle?

573


What are the logical operations?

677


How index is implemented in oracle database?

593


How to revoke create session privilege from a user in oracle?

557






When do we use group by clause in a sql query?

567


Why oracle is used?

578


Is oracle an open source?

632


Briefly explain what is literal? Give an example where it can be used?

542


What is a user account in oracle?

627


What is transport network substrate (tns) in oracle?

585


Design database draw er diagram for a certain scenario ?

4101


How to import one table back from a dump file?

590


Does oracle database need java?

520


What is a schema in oracle?

542