adspace


Difference between join and a subquery?

Answer Posted / katty

When data is to be retrieved from one table based on the condition from another table subquery is used 
When the data is to be retrieved from both the tables join is used

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to put more than 1000 values into an oracle in clause?

1118


Design database draw er diagram for a certain scenario ?

4662


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1960


How to write a left outer join with the where clause in oracle?

1162


How to start an oracle instance?

1107


What is oracle latest version?

1181


How to select all columns of all rows from a table in oracle?

1138


How to use values from other tables in update statements using oracle?

1165