What is equi-join?



What is equi-join?..

Answer / aryasen vaikom

An equijoin is a join with a join condition containing an
equality operator ( = ). An equijoin combines rows that have
equivalent values for the specified columns.
Eg: select * from emp,dept where emp.deptno=dept.deptno;

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Database Management Interview Questions

What's the difference between star and snow flake schema?

0 Answers  


what is database

2 Answers   IBM,


Tell us about some Dot operator queries?

0 Answers   Atos Origin,


How to reorder the table columns (fields)?

0 Answers  


What is the use of ROWS option in EXP command ?

1 Answers  






Why is databases important in healthcare?

0 Answers  


Which is fastest database?

0 Answers  


Write down the differences between nosql and rdbms?

0 Answers  


Can files be stored in a database?

0 Answers  


Is it good to store image in database?

0 Answers  


Why is foreign key used?

0 Answers  


What is the easiest database to learn?

0 Answers  


Categories