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
How do you delete a table?
What is a primary key sql?
What is the difference between between and in condition operators?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is sql a microsoft product?
What is the use of primary key?
What is the purpose of a secondary key?
what are the differences between char and nchar? : Sql dba
How can I delete duplicate rows?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is sql indexing?
What do you mean by table in sql?
how would you enter characters as hex numbers? : Sql dba
How many types of triggers are there in pl sql?
Will truncate release space?
