What are the joins,types of joins and thier functions?
Answer Posted / sree
There are two types of joins
1.Inner joins
2.Outer joins
The outer join is of 3 kinds
- Right join
- Left join
- Full join
Inner join have following characteristics
-return only matching rows
allow max of 32 tables to be joined at the same time
Outer joins--can retrive nonmatching as well as matching
rows.
--outer joins are limited to two tables at a time.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are symget and symput? : sas-macro
What is the difference between the proc sql and data step?
Why double trailing @@ is used in input statement?
What do the PUT and INPUT functions do?
What are the default statistics for means procedure?
what are some good sas programming practices for processing very large data sets? : Sas programming
Explain proc sort?
what is the use of sas management console? : Sas-di
What is the order of application for output data set options, input data set options and SAS statements?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Have you ever used the SAS Debugger?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Explain input and put function?
What is the use of %include statement?
How does the internal authentication work in sas? : sas-grid-administration