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
11. Display the client number and name and the client number and name of the person who referred that client.
How to select an oracle system id (sid)?
What are the differences between char and varchar2 in oracle?
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.
How to create a new view in oracle?
Why is oracle so popular?
What are a cluster and non-cluster index?
Explain the use of Merge statement in oracle 11g
How to assign query results to variables?
What is the use of aggregate functions in oracle?
Is postgres faster than oracle?
What is a cursor in oracle?
What is oracle analytical function?
How to calculate date and time differences in oracle?
What is a proxy object?