1.Self Join 2.Inner Join i.Equi-Join ii.Non-Equi Join 3.Outer Join

Types of joins ?

Question Posted / siva

Answer Posted / siva

1.Self Join
2.Inner Join
i.Equi-Join
ii.Non-Equi Join
3.Outer Join
i.Full Outer Join
11.Left Outer Join
iii.Right Outer Join

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do you modify a trigger?

874

Is hadoop a nosql?

948

how to get help information from the server? : Sql dba

874

What is number function in sql?

912

What is the command used to fetch first 5 characters of the string?

1333

What are conditional predicates?

986

Does sql view stored data?

897

How is a PL/SQL code compiled?

1170

Can we create table inside stored procedure?

903

What is raid? How does it help storage of databases?

1032

What is the difference between a primary key and a clustered index?

929

What does sql stand for?

943

Write a sql select query that only returns each name only once from a table?

958

How would you convert date into julian date format?

946

How to Declare Fixed Length String Value In PL SQL

1101