Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is equi-join?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of database?

1012


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1783


How to select the first record in a given set of rows?

906


Explain the importance of partitioning.

985


What is the maximum line size that dbms_output can handle?

1164


What is rdbms architecture?

914


What is dbms with example?

1035


What do you mean by transparent dbms?

1417


Write a query to create a duplicate table with and without data present?

857


What are database functions?

889


List few disadvantages of file processing system.

929


How to export data from database and import into another?

920


What is the use of drop command and what are the differences between drop, truncate and delete commands?

1101


What is the role of database management system?

947


Explain the difference between two and three-tier architectures.

934