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
explain access control lists. : Sql dba
What is the difference between view and stored procedure?
What is not equal in sql?
What are different types of functions in sql?
What is the use of <> sql?
How do you optimize a query?
What is nosql vs sql?
Can we join more than 2 tables in sql?
Which table is left in join?
what is a composite primary key ? : Sql dba
Show code of a cursor for loop.
Is it possible to read/write files to-and-from PL/SQL?
how tsql statements can be written and submitted to the database engine? : Transact sql
explain the options of myisamchk to improve the performance of a table. : Sql dba
How can you view the errors encountered in a trigger?