Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Analysis Interviews:AnalysisAnalystAnalyst IntegrationAnalyst IntegrationAnecdotalBusiness AnalystCompetency BasedCredit AnalystCrime Scene AnalystData AnalystEmotional IntelligenceEvent PlannerExecutive Business AnalysisExecutive Business DevelopmentFemale SecretaryFinancial AnalystGISGIS AnalysisGIS DateMarket Research AnalystPension ExaminerPhone ScreeningPre EmploymentPre Employment ScreeningRecruitment/Research AnalystResearch AnalystResearch OfficerSales AnalystSpatial DataStatic AnalysisStatics MeasuresStatisticsSystem Analysis
Copyright © 2018. All Rights Reserved
Analyst Integration Interview Question:
Explain inner join and a left join in SQL?
Submitted by: AdministratorIn SQL, there are mainly two types of joins, inner join and outer join. Again outer joins can be two types right and left outer join. Main difference between inner join and left join is that in case of former only matching records from both tables are selected while in case of left join, all records from left table is selected in addition to matching records from both tables. Always watch out for queries which has "all" in it, they usually require left join e.g. write sql query to find all departments and number of employees on it. If you use inner join to solve this query, you will missed empty departments where no one works.
Submitted by:
Submitted by:
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.