tag:blogger.com,1999:blog-5562253332413822713.post1466964293068441386..comments2024-02-19T10:26:36.166-08:00Comments on SQL Server Interview Questions: Left Join with an exampleUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5562253332413822713.post-43111666667473953832017-03-16T23:40:34.667-07:002017-03-16T23:40:34.667-07:00We will get 100K records in Left Join and 50K reco...We will get 100K records in Left Join and 50K records in right join.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-65665174107231509892017-01-03T05:45:10.140-08:002017-01-03T05:45:10.140-08:00will get 100 K records by using left join and 50 K...will get 100 K records by using left join and 50 K by using right joinAnonymoushttps://www.blogger.com/profile/05897576812780111443noreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-72840448574073106612016-12-01T07:46:34.955-08:002016-12-01T07:46:34.955-08:00i think we will get 100k records for left join and...i think we will get 100k records for left join and 50k records for right join.<br />vinodhttps://www.blogger.com/profile/05953357593689938063noreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-1696531116669583852016-09-17T12:24:44.916-07:002016-09-17T12:24:44.916-07:00u will get 100 records in each join u will get 100 records in each join Anonymoushttps://www.blogger.com/profile/05959669659638744247noreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-33584084620574997042016-05-16T05:06:38.458-07:002016-05-16T05:06:38.458-07:00hi venkat,
one question is asking me in intervi...hi venkat,<br /> one question is asking me in interview.if left table have 100K records , right table 50K records and 100 matching records.then how many record will retrived by left join and right join .pls ans this qus.Anonymoushttps://www.blogger.com/profile/05584657982018556568noreply@blogger.com