The SQL query SELECT columns FROM TableA RIGHT OUTER JOIN TableB ON…
2020
The SQL query
SELECT columns
FROM TableA
RIGHT OUTER JOIN TableB
ON A.columnName = B.columnName
WHERE A.columnName IS NULL returns the following:
- A.
All rows in Table B, which meets equality condition above and, none from Table A, which meets the condition
- B.
All rows in Table A, which meets equality condition above and none from Table B, which meets the condition
- C.
All rows in Table B, which meets equality condition
- D.
All rows in Table A, which meets equality condition
- E.
None of these
Attempted by 251 students.
Show answer & explanation
Correct answer: E
Query returns records of table B which are failed equality condition of join. Option (E) is correct.
A video solution is available for this question — log in and enroll to watch it.