Whatz the main diff between Subquery and a Join

Answer Posted / adil khan

main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

11. Display the client number and name and the client number and name of the person who referred that client.

1918


How to select an oracle system id (sid)?

581


What are the differences between char and varchar2 in oracle?

560


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1528


How to create a new view in oracle?

611






Why is oracle so popular?

558


What are a cluster and non-cluster index?

572


Explain the use of Merge statement in oracle 11g

592


How to assign query results to variables?

590


What is the use of aggregate functions in oracle?

577


Is postgres faster than oracle?

557


What is a cursor in oracle?

644


What is oracle analytical function?

524


How to calculate date and time differences in oracle?

528


What is a proxy object?

579