Answer Posted / lakshminrayana reddy
5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the difference between delete, truncate and drop command?
What are conditional predicates?
Is left join same as join?
Can we use commit inside a trigger?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
what is a database lock ? : Sql dba
Define commit?
What is restrict in sql?
what are the authentication modes in sql server? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How to get unique records from a table?
Why do we use joins in sql?
What is sql indexing?
Explain what is table in a database?
what are the differences among rownum, rank and dense_rank? : Sql dba