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
List out the components of logical database structure of oracle database.
Does facebook use oracle?
What are the logical operations?
How index is implemented in oracle database?
How to revoke create session privilege from a user in oracle?
When do we use group by clause in a sql query?
Why oracle is used?
Is oracle an open source?
Briefly explain what is literal? Give an example where it can be used?
What is a user account in oracle?
What is transport network substrate (tns) in oracle?
Design database draw er diagram for a certain scenario ?
How to import one table back from a dump file?
Does oracle database need java?
What is a schema in oracle?