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
How do you connect the desktop application to metadata server? : sas-grid-administration
what is sas olap server? : Sas-di
where are dashboard components are created and maintained? : Sas-bi
what is sas database server? : Sas-di
How to sort in descending order?
How do you control the number of observations and/or variables read or written?
Name and describe few sas character functions that are used for data cleaning in brief.
why is sas data integration studio important? : Sas-di
What is the function of Stop statement in a SAS Program?
explain the proc in sas? : Sas-administrator
What is the sas data set? : sas-grid-administration
What are the features of base sas system?
it will become easy if uuu provide website linkssss and list of consultanciessssss
how to do user inputs and command line arguments in sas?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi