Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 2)
2.
What type of join is needed when you wish to return rows that do have matching values?
Discussion:
13 comments Page 1 of 2.
Amol said:
1 decade ago
"all of the above" is correct answer because. Outer join returns the row having matching as well as non matching values.
Alelign said:
9 years ago
Yes, the correct answer is D because outer join returns both values that have the same and different values.
(1)
Narasimhulu said:
6 years ago
The correct answer is C, Outer join returns the row having matching as well as non-matching values.
Kala said:
1 decade ago
Equi join is correct. Outer join gives non matching values. Equi join gives matching values.
Pachi said:
9 years ago
Yes, option D is right one. Because also outer join return matching rows from both tables.
Rajkumar said:
1 decade ago
Non equi-join is return rows that do have matching values.
Rishabh said:
1 decade ago
Equi-join both side same value then you used simple join.
Habtamu said:
1 decade ago
@Amol
From the 4 choice which one is more answerable?
From the 4 choice which one is more answerable?
Sakhile said:
7 years ago
How it should be D? Please explain the answer to me.
Hema said:
1 decade ago
Equi join is the correct one for match values.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers