What are the different types of joins and explain them
briefly.

Answer Posted / hindol

equi join ,
non-equi join,
self join,
outer join,
cross join.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are date and time data types? : Sql dba

701


What is the difference between a procedure and a function?

699


Why we use triggers in mysql?

726


What is attribute indicator in pl sql?

718


is mysql query is case sensitive? : Sql dba

773






what are the advantages of using stored procedures? : Sql dba

822


What are different clauses used in sql?

813


What are the possible values that can be stored in a boolean data field?

716


What are the main features of cursor?

824


What is the use of double ampersand (&&) in sql queries? Give an example

811


What are three advantages to using sql?

732


Define SQL and state the differences between SQL and other conventional programming Languages?

871


Which function is used to return remainder in a division operator in sql?

785


What are all different types of collation sensitivity?

737


Can cursors be part of a trigger body?

1349