Interested to Buy Any Domain ? << Click Here >> for more details...
tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
- 3 Answers
- 8851 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / subhash
OUTPUT:
1, a, d
2, b, NULL
3, NULL, c
SQL Query:
SELECT * FROM TAB1 FULL OUTER JOIN TAB2 ON
TAB1.key_column=TAB2.key_column;
or
SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column=TAB2.key_column(+)
UNION
SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column(+)=TAB2.key_column;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What steps should be taken to improve Datastage jobs?
What are the types of containers and how to create them?
What is the difference between hashfile and sequential file?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the types of hashed files in data stage
Explain datastage architecture?
What is the difference between odbc and drs stage?
What is staging variable?
Define data aggregation?
Why do you need stage variables?
What are the stages in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
why do u need the IOS upgradation in a FC switch
What are the steps needed to create a simple basic datastage job?
What is the difference between validated and compiled in the datastage?
