Types of joins ?

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


Please Help Members By Posting Answers For Below Questions

What is the current version of postgresql?

732


What is a procedure in pl sql?

774


Explain the components of sql?

786


What are different types of triggers?

736


How to revise and re-run the last sql command?

831






What is data profiling in sql?

733


what are the non-standard sql commands supported by 'mysql'? : Sql dba

770


Is sql a backend?

766


What is using in sql?

785


What is loop in pl sql?

759


What is trigger and how to use it in sql?

723


Is sql open source?

711


What is the sql case statement?

744


What is secondary key?

667


Show the cursor attributes of pl/sql.

775