Types of joins ?

Answer Posted / ganesh

hai
1.Equi Join
2.Non-Equi Join
3.Cartesian Join
4.outer Join(+)(Left Outer Join/Right Outer Join)
5.Self Join

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I partition a table in sql?

726


What is memory optimized table?

761


How can I see all tables in sql?

726


How can we avoid duplicating records in a query?

735


State some properties of relational databases?

752






What are the types of triggers in sql?

694


What is package in pl sql with an examples?

725


What are stored procedures in mysql?

757


What is sql prepared statement?

735


What is minus?

747


What is faster join or subquery?

705


How do you update a sql procedure?

761


Is left join same as inner join?

720


Why do we use set serveroutput on?

687


What are the benefits of triggers?

887