What are different types of joins ?

Answer Posted / amit das

1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is there a need for sqlcode and sqlerrm variables?

591


how to increment dates by 1 in mysql? : Sql dba

549


What is the use of index in hive?

555


What is a trigger in sql?

646


How to download oracle sql developer?

672






In what condition is it good to disable a trigger?

566


Write a query to display the current date in sql?

528


How many functions are there in sql?

554


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

558


What are dml commands?

540


What are the advantages of normalization?

565


What do you mean by dbms? What are its different types?

559


What does (*) mean in sql?

535


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

629


How is pl sql different from sql?

557