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 / kush

Joins are used to join the datasets horizontally.

There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.

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

Left join gives all the records that are present in left
dataset and matching records in right dataset.

Right join gives all the records in the right dataset and matching records in left datasets

full join gives all matching and non matching records found in both the datasets.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are sas/access and sas/connect? : Sas programming

1039


What do the SAS log messages "numeric values have been converted to character" mean?

1428


How do you specify the number of iterations and specific condition within a single do loop?

1152


explain what is factor analysis? : Sas-administrator

1172


where are dashboard components are created and maintained? : Sas-bi

1058


Give e an example of..

2382


What do the mod and int function do? : Sas programming

1305


What are the functions which are used for character handling functions?

1189


What is PDV?

1205


What are the new features included in the new version of SAS Programming Language?

1249


Describe crosslist option in tables statement?

1263


What are the special input delimiters used in SAS?

1238


Which statement does not perform automatic conversions in comparisons?

1856


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3552


Differentiate between proc means and proc summary.

1102