Search Interview Questions
| More than 3000 questions in repository.|
There are more than 900 unanswered questions.
Click here and help us by providing the answer.
Have a video suggestion.
Click Correct / Improve and please let us know.
|Interview Questions and Answers|
|Ans. Inner join is the intersection of two tables on a particular columns whereas Outer Join is the Union of two tables.|
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve  sql   joins   inner join   outer join Asked in 3 Companies basic   frequent|
|What are Inner , Outer , Left and Right Joins in SQL ?|
| What is a self Join and give an example of a self Join ?|
What is self Join and What is it's purpose ?
|If Table A has 100 records and Table B has 50 records , how many records will the left join of Table A with Table B generate ?|
|If Table A has 100 records and Table B has 50 records , how many records will the right join of Table A with Table B generate ?|
|If Table A has 0 records and Table B has 50 records , how many records will the equi join of Table generate ?|
|What is Left Outer Join ?|
|Describe SQL Joins|
|create an SQL query across multiple tables involving outer joins|
|Explain Working of joins in sql.|