Types of joins ?

Answer Posted / lakshminrayana reddy

5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When can we use the where clause and the having clause?

574


What do you mean by “trigger” in sql?

613


How do you create a unique index?

565


how to concatenate two character strings? : Sql dba

542


What are the sql versions?

512






What is the difference between row level and statement level trigger?

510


Name some usages of database trigger?

556


Does truncate table reset auto increment?

520


What are the different types of dbms?

546


how is exception handling handled in mysql? : Sql dba

545


What is sql select statement?

498


how many ways to get the current time? : Sql dba

521


Is trigger a stored procedure?

498


What is number function in sql?

523


Can we use threading in pl/sql?

511