Select from following answers:- Cross Join
- Self Join
- Inner Join
- Equi Join
- All Above
Above query is a type of Self Join.Because self join is applied on the same table,but we have to give an Alias name to work fine. Self join is treated as Cross join meaning that it also produces Cartesian product meaning if employee_master is having 50 records then after applying self join, it will produce 2500 rows.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator