You need to write a new query that will return names from the employee table for people who are not part of the contractors table (the two tables share a unique id, similar to social security or NI number). Your query will use a sub query to check that the employee is not in the contractors table. How might you achieve this?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 470 | Points: 40
Select from following answers:
  1. Use COALESCE
  2. Use EXISTS
  3. Use IS_MEMBER
  4. Use EXP
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response