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

What is a crud api?

502


What does := mean in pl sql?

555


Explain what is an index?

595


What is dbo in sql?

536


What is the difference between jpql and sql?

555






Can we create table inside stored procedure?

532


What is pl sql variable?

510


what is the bond code in materialized view?

2489


What is trigger with example?

566


What is a sql*loader control file?

622


Do we need to rebuild index after truncate?

529


What are the types of sql commands?

553


What is sql catalog?

568


Explain dml and ddl?

552


What is union?

651