adspace


What are different types of joins ?

Answer Posted / sreekanth

Basically there are 5 types of joins, they are

1.Equi join
2.Non-equi join
3.cartegian join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use regular expression in pattern match conditions? : Sql dba

1125


Can we rollback truncate?

1083


how many tables will create when we create table, what are they? : Sql dba

1156


how to escape special characters in sql statements? : Sql dba

1124


how to start mysql server? : Sql dba

1279


What is your daily office routine?

2353


what are all the common sql function? : Sql dba

1141


Does group by remove duplicates?

1120


what are the advantages of sql ? : Sql dba

1154


How do I remove duplicates in two columns?

1202


what is bcp? When does it used? : Sql dba

1065


What is the current version of postgresql?

1188


what is collation? : Sql dba

1242


Is primary key always clustered index?

1101


what is schema? : Sql dba

1163