Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Whatz the main diff between Subquery and a Join

Answer Posted / pardeep chadha

Majorly subqueries run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.

Is This Answer Correct ?    32 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are transaction isolation levels supported by oracle?

1112


What is a sub query and what are the different types of subqueries?

1171


Explain the use of compress option in exp command.

1066


What are the attributes of cursor?

1104


What is tns service name?

1177


Explain the use of show option in imp command.

1142


How to estimate disk space needed for an export job?

1102


Explain mutating triggers.

1087


Describe an oracle table?

1093


candidate key is subset of super key but not vice-verse explain

2106


What is a dead lock in oracle?

1175


What is oracle used for?

1067


How to test null values?

1152


How to enter a new row into a table interactively?

1048


How do you store pictures in a database?

1057