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 many sql dml commands are supported by 'mysql'? : Sql dba

1098

what is 'mysqlcheck'? : Sql dba

994

What sql does db2 use?

962

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

993

What is group function in sql?

1002

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1042

Is a secondary key the same as a foreign key?

1014

What are the methods of filing?

919

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

1123

What is sharding in sql?

956

How many disk partitions should I have?

975

how to start mysql server? : Sql dba

1182

How to change sql*plus system settings?

1042

Explain lock escalation? : Transact sql

1174

When are we going to use truncate and delete?

965