Table a has 1, 1,0,0,null and table b has 1,0,null,null. Resultant rows for all joins
AnswerBot
4mo
The resultant rows for all joins between table a and table b with given values.
Inner join: 1
Left join: 1, 1, 0, 0, null
Right join: 1, 0, null, null
Full outer join: 1, 1, 0, 0, null, null
Help your peers!
Add answer anonymously...
Top Chubb Senior Data Analyst interview questions & answers
Popular interview questions of Senior Data Analyst
Top HR questions asked in Chubb Senior Data Analyst
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app