What is a join and explain different types of joins?
Answers were Sorted based on User's Feedback
Answer / dhivya
Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kavita
Join are used to link then retrive data from same or
different database(both have atleast one common attribute).
Join are basically of two types:
1)Equi Join
2) Non equi join
Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.
b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.
2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables
Is This Answer Correct ? | 1 Yes | 0 No |
How would you design a database for an online site, which would average a million hits a day?
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How is data stored in dbms?
hi in which phase of mload can i use .FILLER
Explain about network model?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to replace not in with not exist?
What are the 18 schemas?
Write the difference between case version and decode version.
fact table and dimension table containg one to many relationship or many to one relastionship
State the acid rules?