SQL Query Writing:
**TABLE A**
Columns: Col1 col2 Col3
Data: 1 ABCD 987
1 CDER 234
1 MBCV 444
1 VCXDF 345
**TABLE B**
Columns: Col1 col4 Col5
Data: 1 cd 123
1 VG 876
1 XX 456
1 CC 765
Task: Implement Inner join, Left Outer join and Full outer join and provide the number of output records for each type of join?

Question

SQL Query Writing:
**TABLE A**
Columns: Col1 col2 Col3
Data: 1 ABCD 987
           1 CDER 234
           1 MBCV 444
           1 VCXDF 345
**TABLE B**
Columns: Col1 col4 Col5
Data: 1 cd 123
           1 VG 876
           1 XX 456
           1 CC 765
Task: Implement Inner join, Left Outer join and Full outer join and provide the number of output records for each type of join?

Siemens

Siemens interview question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches