PrepAway - Latest Free Exam Questions & Answers

How might you achieve this?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Use COALESCE

B.
Use EXISTS

C.
Use IS_MEMBER

D.
Use EXP


Leave a Reply