What are the different types of joins and explain them
briefly.

Answer Posted / hindol

equi join ,
non-equi join,
self join,
outer join,
cross join.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the authentication modes in sql server? : Sql dba

528


What is a string data type in sql?

512


describe transaction-safe table types in mysql : sql dba

502


Can we create table in function?

566


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

510






What are the different types of joins in sql?

579


Does truncate table reset auto increment?

528


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

489


What is not null in sql?

573


What are hotfixes and patches?

527


What is triggering circuit?

592


how to select unique records from a table? : Sql dba

628


How can we find duplicate records in a table?

512


How do you drop a trigger?

540


What is dcl in sql?

526