Answer Posted / mathan kumar
Two Type of Joins are there
1) Inner Join
2) Outer Join
In Inner join has 3 types they are as follows
a)Equi join
b)Cross Join
c)Natural Join
In Outer join has 3 types they are as follows
a)Left Outer Join
b)Right Outer Join
c)Full Outer Join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the advantages of sql ? : Sql dba
What is the current version of sql?
What is the current version of postgresql?
what are aggregate and scalar functions? : Sql dba
Can we use distinct and group by together?
What is the best sql course?
What is your daily office routine?
Is primary key clustered index?
what is sql server agent? : Sql dba
Is primary key always clustered index?
How do I remove duplicates in two columns?
Can we rollback truncate?
what is dbms? : Sql dba
Can delete statement be rollbacked?
how to use regular expression in pattern match conditions? : Sql dba