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

How many functions are there in sql?

715


Is it possible to create the following trigger: before or after update trigger for each row?

913


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

652


What is sql profiling in oracle?

734


Is sql pronounced sequel or sql?

950






what is denormalization. : Sql dba

763


Why do we use view in sql?

724


write an sql query to find names of employee start with 'a'? : Sql dba

773


What is ttitle and btitle?

766


Which normal form is best?

671


What is sql resultset?

722


What is composite primary key in sql?

707


Can you select everything, but 1 or 2 fields, without writer's cramp?

685


what is view? : Sql dba

726


What is user defined functions?

740