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...


Types of joins?

Answers were Sorted based on User's Feedback



Types of joins?..

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

Types of joins?..

Answer / deeksha

4 types
1.equijoin
2.non-equijoin
3.self join
4.outer join

Is This Answer Correct ?    3 Yes 0 No

Types of joins?..

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

Types of joins?..

Answer / roopesh kumar

(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

Post New Answer

More SQL PLSQL Interview Questions

What are the two types of exceptions in pl/sql?

0 Answers  


check whether all the emp numbers are indeed unique.

6 Answers  


How many types of triggers are there in pl sql?

0 Answers  


how many ways to get the current time? : Sql dba

0 Answers  


wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,


What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,


How do I order columns in sql?

0 Answers  


What are the advantages of indexing?

0 Answers  


Does inner join remove duplicates?

0 Answers  


What is a parameter query?

0 Answers  


How to display the contents of a current record fetched in a reference cursor?

2 Answers  


If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  


Categories