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 are the joins,types of joins and thier functions?

Answer Posted / mehul thakkar

There are basically three types of joins,
1. Inner Join
2. Left Join
3. Right Join

Inner Join gives the records which are present in both the
datasets.

Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.

Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.

Is This Answer Correct ?    6 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name any two sas spawners? : sas-grid-administration

1037


explain what is factor analysis? : Sas-administrator

1110


explain the proc in sas? : Sas-administrator

1086


Describe the ways in which you can create macro variables?

1189


what is the primary data source for the wrs? : Sas-bi

1229


What is the use of function Proc summary?

1278


What is the difference between match merge and one to one merge?

1244


Mention the category in which sas informats are placed?

1014


how does sas handle missing values in a merge? : Sas programming

1044


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1281


What’s the difference between var b1 – b3 and var b1 — b3?

1358


Are you involved in writing the inferential analysis plan? Tables specfications?

2221


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2074


How to create an external dataset with sas code?

1150


name several ways to achieve efficiency in your program? : Sas programming

1062