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

What is a join?Explain the different types of joins?

Question Posted / pratap

Answer Posted / pratap

Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Equi join(i.e. Inner join)
2. self join
3. left join
4. right join
5. outer join

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

976

What does count (*) mean?

925

Can we use update in sql function?

1052

What are the types of queries in sql?

1076

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1131

what is 'trigger' in sql? : Sql dba

1076

What is mdb stand for?

1003

What is a heap in sql?

1055

what is the difference between nested subquery and correlated subquery?

1045

Which function is used to return remainder in a division operator in sql?

1128

Can a key be both primary and foreign?

986

How to place comments in pl/sql?

1148

Which version of sql do I have?

1048

What is pl sql code?

1042

What is use of trigger?

928