Assuming UserProfile is a table with PKUserId int,Profession Varchar(50)columns. What is the result of the below query:
SELECT PKUserId,Profession
FROM UserProfile
WHERE Profession = 'Engineer' AND (PKUserId > 12 OR PKUserId = 1) ?

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 2310 | Points: 40
Select from following answers:
  1. Displays Users with Profession as 'engineer' with PKUserId > 12 as well as the users with PKUserId of 1.
  2. Displays Users with Profession as 'engineer' with PKUserId > 12 only.
  3. Displays Users with Profession as 'engineer' with PKUserId of 1 only.
  4. None of the above.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response