What are different types of joins ?

Answer Posted / t.rajesh gupta

Different types of joins are 1.self join, 2. Equi join, 3.
non-equi join 4. cross join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define join and name different types of joins?

520


What is trigger in sql?

582


How do you truncate?

507


Is sqlexception checked or unchecked?

541


Mention what are different methods to trace the pl/sql code?

562






What is user in sql?

583


What is the meaning of disabling a trigger?

647


Does google use sql?

513


Explain select statements in sql?

591


What is substitution variable?

583


Why is sql*loader direct path so fast?

601


How delete all records from table in sql?

554


What is a data manipulation language?

571


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

906


What are the different schemas objects that can be created using pl/sql?

530