Types of joins?

Answer Posted / roopesh kumar

(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch alternate records from a table?

784


what does it mean to have quoted_identifier on? : Sql dba

779


What is secondary key?

591


Which tcp/ip port does sql server run?

623


What is a call statement? Explain with an example.

644






What are the types of sql commands?

658


What is the difference between nvl function, ifnull function, and isnull function?

687


How do I trace sql profiler?

596


Why is sql important?

671


What is sp_helptext?

684


What is primary key and foreign key with example?

580


What is function and procedure in pl sql?

602


How can we find duplicate records in a table?

589


What is the use of primary key?

633


What is sqlcontext?

627