1-Inner Join 2-Outer Join 3-Left Join 4-Right Join 5-Self Join

What are different types of joins ?

Question Posted / amar misra

Answer Posted / amar misra

1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I delete a trigger?

968

Is primary key clustered index?

952

What is numeric function sql?

1066

What is the difference between left and left outer join?

949

Does sql require a server?

1019

Is inner join faster than left join?

1191

Define commit?

1009

Explain the update statement in sql

995

What are triggers and its types?

1069

What is snowflake sql?

1079

What is partition by in sql?

1071

Write the command to remove all players named sachin from the players table.

1184

Why is sql*loader direct path so fast?

1108

what is the functionality of the function htmlentities? : Sql dba

970

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1142