Which Transact-SQL statement should you run?

You have a database named MyDb.

You run the following Transact-SQL statements:

A value of 1 in the IsActive column indicates that a user is active.

You need to create a count for active users in each role. If a role has no active users. You must display a zero as the active users count.

Which Transact-SQL statement should you run?

A)

B)

C)

D)

E)

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

View Answer

Answer: A

Explanation:

Incorrect Answers:

C: count (*) always give 1 as it will have some data in the overall table