adspace


What are different types of joins ?

Answer Posted / amit das

1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what are the advantages of sql ? : Sql dba

1154


Can we use distinct and group by together?

1147


what is dbms? : Sql dba

1070


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

1124


What is your daily office routine?

2353


Is inner join faster than left join?

1287


What is the current version of postgresql?

1188


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

1065


What is the best sql course?

1064


Is primary key clustered index?

1028


what is collation? : Sql dba

1242


Can we rollback truncate?

1083


what are all the common sql function? : Sql dba

1141


what is sql server agent? : Sql dba

1189