Types of joins?
Answers were Sorted based on User's Feedback
Answer / sangeetha meda
1. Self Join
Self join is a query in which a table is Joined to itself.
Self joins are used to compare the values in a column to
the other values in the same column in the same table.
2.Equi Join or Inner join
Equi join is a join in which the rows are retrieved the
equality of the relation ship between columns in the tables.
Select only those rows that have values in common in the
columns specified in the ON clause.
3.Non Equi Join or Outer Join
Left Outer Join:
Retrieves the matching records in both the table and non
matching records in the first or left table.
Right Outer Join
retrieves the matching records in both the table and non
matching records in the second or the right table.
Full Outer Join
Retrieves all the records (means matching and non matching
records in both the tables).
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / deeksha
4 types
1.equijoin
2.non-equijoin
3.self join
4.outer join
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mohana sundaram
self joins,natural joins,cross joins,inner joins,outer
joins,equi and nonequi joins.
Is This Answer Correct ? | 2 Yes | 0 No |
(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join
Is This Answer Correct ? | 2 Yes | 0 No |
What are sql functions? Describe the different types of sql functions?
how would you get the current date in mysql? : Sql dba
what is the difference between clustered and non clustered index in sql? : Sql dba
what is 'mysqlcheck'? : Sql dba
What sql does db2 use?
What is relationship? How many types of relationship are there?
How to display Row Number with Records in Oracle SQL Plus?
Explain uses of cursor.
how can we destroy the cookie? : Sql dba
Can we join more than 2 tables in sql?
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
What does fetching a cursor do?