What will be the output of

SELECT X
FROM (VALUES('1'), (NULL)) AS T(X)

INTERSECT

SELECT X
FROM (VALUES(NULL), (NULL)) AS T(X)

 Posted by Rajnilari2015 on 11/16/2015 | Category: Sql Server Interview questions | Views: 2041 | Points: 40
Select from following answers:
  1. 1
  2. NULL
  3. Error
  4. 2 rows - 1 and NULL
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response