Difference between join and a subquery?
- 8 Answers
- 45572 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / kiran
subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins
| Is This Answer Correct ? | 39 Yes | 5 No |
Post New Answer View All Answers
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to select all columns of all rows from a table in oracle?
How to put more than 1000 values into an oracle in clause?
How to use values from other tables in update statements using oracle?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
