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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Types of joins?

Question Posted / geethu

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 packages in pl sql and also explain its advantages?

0 Answers  

What are analytical functions in sql?

0 Answers  

..........refers to the disk mirroring

2 Answers   iFlex,

Why are cursors used?

0 Answers  

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

What do we need to check in database testing?

0 Answers  

Why are aggregate functions called so?

0 Answers  

What are the different datatypes available in PL/SQL?

0 Answers  

Mention what are the benefits of pl/sql packages?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

What is mdb stand for?

0 Answers  

how to create a new table in mysql? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories