Interview Questions and Answers for 'Fannie mae' | Search Interview Question

Interview Questions and Answers for 'Fannie mae' - 1 question(s) found - Order By Newest

Q1. What is a self Join and give an example of a self Join ?

or

What is self Join and What is it's purpose ?

Ans. When a Table Join itself , it's a Self Join. For example - we like to know the pair of department names where first dept has lesser employees than the later.

Select D1.name , D2.name from Dept D1, Dept D2 where D1.employee_count < D2.employee_count

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql joins self join self-join Pair of employee names with first having lesser salary than later Pair of department names where first dept has lesser employees than the later Asked in 26 Companies basic frequent}