What are the joins,types of joins and thier functions?
Answer Posted / shwetha
1.simple join:-to report matching data from various tables
2.inner join:- to report data.Conditional clause implemented
by on clause.For inner & outer join.
3.outer join:- left join:-to report data from the left side
table & matching data from right side table,right
join:-report overall data from right side& matching data
from the left side table,full join:- report overall data
from both tables & matching.
union join:- adding & combining.
self join:-the table join with same table
natural join:- report matching data from the variable tables
without using conditions.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the differnce between SDTM 3.1.2 to 3.1.1 version
how will you location sas platform applications available from web browser? : Sas-bi
what is business intelligence? : Sas-bi
Explain the use of proc print and proc contents?
Are you involved in writing the inferential analysis plan? Tables specifications?
What would be the value of month at the end of data step execution and how many observations would be there?
Describe a time when you were really stuck on a problem and how you solved it?
Are you involved in writing the inferential analysis plan? Tables specfications?
Explain the difference between informat and format with an example.
what is sas olap server? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
what is the use of proc contents and proc print in sas? : Sas-administrator
Explain translate function?
name several ways to achieve efficiency in your program? : Sas programming
what are the component of range? : Sas-bi