Answer Posted / a.jyothsna
1) SELF JOIN
2) EQUI JOIN(OR) INNER JOIN
2.1) NON-EQUI JOIN
3)OUTER JOIN
3.1) LEFT OUTER JOIN
3.2) RIGHT OUTER JOIN
3.3) FULL OUTER JOIN
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to sort the rows in sql.
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Are dml statements autocommit?
What is use of package in pl sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the left table in sql?
what are date and time data types? : Sql dba
What are pl/sql cursors?
how to rename an existing column in a table? : Sql dba
What does 0 mean in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is difference between inner join and cross join?
Explain ttitle and btitle.
Can there be more than one function with a similar name in a pl/sql block?
What are the different types of constraints?