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

what is cross join? : Sql dba

994

Why functions are used in sql?

988

How to add a column ‘salary’ to a table employee_details?

1012

How do you clear the screen in sql?

1064

What is rank () in sql?

933

What is bind variable in pl sql?

1051

What is pragma in pl sql?

1104

Is sql a programming?

970

What does seeding a database mean?

952

What are the topics in pl sql?

970

how can we optimize or increase the speed of a mysql select query? : Sql dba

940

what is error ora-03113: end-of-file on communication channel?

1158

How many times can we commit in a loop?

1014

What is composite primary key in sql?

996

what is column? : Sql dba

1002