1)Inner Join a)Equi join b)Natural Join c)Cross Join 2)Outer Join

Types of joins ?

Question Posted / anuadarsh

Answer Posted / anuadarsh

1)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

What is use of trigger?

875

Does sql*plus have a pl/sql engine?

997

In pl/sql, what is bulk binding, and when/how would it help performance?

938

How to revise and re-run the last sql command?

1101

Can you rollback after commit?

936

Does sql profiler affect performance?

942

What is an intersect?

1047

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

971

How does index help in query performance?

968

What is the plv (pl/vision) package offers?

981

What is the use of non clustered index?

930

How do I write a sql query in pgadmin 4?

927

Explain 3 basic parts of a trigger.

1257

What is a full join?

912