what are the different types of joins?

Answer Posted / desiraju venkata subramanya ka

types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does varchar include?

525


How do you declare a variable in pl sql?

543


How many aggregate functions are available there in sql?

536


Why are indexes and views important to an organization?

531


How to create a menu in sqlplus or pl/sql?

618






Does inner join remove duplicates?

530


What is cte sql?

525


What is difference between sql and excel?

523


What are different methods to trace the pl/sql code?

548


What is sql character function?

549


Is a secondary key the same as a foreign key?

498


What is sql injection vulnerability?

500


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

549


Explain the difference between triggers and constraints?

530


What is break?

632