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

What is a join and explain different types of joins?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2267


Which data type cannot be used as a parameter in a udf?

1024


Explain about the storage and physical database design?

970


On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1053


How to customize error conditions.

2198


explain detail about ftp in datastage?

2296


fact table and dimension table containg one to many relationship or many to one relastionship

2549


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1023


Explain about a primary key?

1043


Explain about the hierarchical model of the database?

1168


How is data stored in dbms?

1010


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2104


How to use timestamp datatypes

2079


Explain the rollup operator?

1143


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1073