Types of joins ?

Answer Posted / guest

1.Simple/Inner/Natural Join
2.Equi(contains only = sign) /Non-Equi Joins(other simbles)
3.Outer Joins(Left Outer Join/Right Outer Join)
4.Cross Join
5.Self Join

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does cross join work?

496


What are variables in pl sql?

554


What is schema in sql example?

595


How does join work in sql?

546


What is raid? How does it help storage of databases?

594






define data blocks ? : Sql dba

539


What is user defined functions?

569


what are the different tables present in mysql? : Sql dba

496


What do you mean by dbms? What are its different types?

551


What is microsoft t sql?

486


Should I use mbr or gpt?

532


What is materialized view in sql?

456


Are left and right joins the same?

525


Can we use the cursor's to create the collection in PL/SQL?

511


give the syntax of grant and revoke commands? : Sql dba

607