Question: Subquery vs Join
Answer: subquery retrive the data depending on certain condition or manupulation in inner query.where as joins will join the enitire data depending on the conditions given it cannot manupulate the data or we cannot be selective while using joins
subquery retrive the data depending on certain condition or manupulation in inner query.where as joins will join the enitire data depending on the conditions given it cannot manupulate the data or we cannot be selective while using joins Source: CoolInterview.com
Subquery is use to retrive data which have multiple conditions.join is use to give joint to 2 different table using a same field of different table it will retrive data from two different table. Source: CoolInterview.com
Rules to Post Answers in CoolInterview.com:- There should not be any Spelling Mistakes. There should not be any Gramatical Errors. Answers must not contain any bad words. Answers should not be the repeat of same answer, already approved. Answer should be complete in itself.
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.