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 is left join example?
What is the difference between truncate and drop statements?
Explain the working of foreign key?
How is indexing done in search engines?
How to run pl/sql statements in sql*plus?
What are string functions in sql?
What is the difference between null value, zero, and blank space?
What is the difference between the conventional and direct path loads? : aql loader
What is pl/sql table? Why is it used?
Which is better varchar or nvarchar?
Why we use joins in sql?
How do I save a sql query?
Are null values same as that of zero or a blank space?
Explain clause in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql