Which Transact-SQL statements should you run?

You develop a Microsoft SQL Server database that contains tables as shown in the exhibit. (Click the Exhibit button.)

You need to retrieve a list of clients for whom there is no corresponding information in the Projects table.

Which Transact-SQL statements should you run?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: A

Explanation:

References: https://www.dofactory.com/sql/select-distinct https://www.dofactory.com/sql/right-outer-join