What are different types of joins ?

Answer Posted / t.rajesh gupta

Different types of joins are 1.self join, 2. Equi join, 3.
non-equi join 4. cross join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an ndf file?

542


Can we update views in sql?

543


What are the triggers associated with image items?

629


What is a subquery in sql?

519


Explain locks? : Transact sql

581






How are sql commands classified?

601


What is procedure explain with example?

548


How do you update f as m and m as f from the below table testtable?

1115


What is difference between stored function and application function?

603


What is the difference between numeric and autonumber?

506


what is text? : Sql dba

576


what is the difference between myisam static and myisam dynamic? : Sql dba

594


What are the three pl sql block types?

583


what is bcp? When is it used?

590


What is self-join and what is the requirement of self-join?

646