Select from following answers:- Self Joins are used with or without where condition.
- Self Joins are always used on single table.
- Self Joins when combined produce cartesian product.
- All of the above.
- All Above
Above all statements are correct about Self Joins.
For Example:-
select a.id,a.name,b.id,b.name from test1 a,test1 b;
select a.id,a.name,b.id,b.name from test1 a,test1 b where a.id = 1;
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator