If you wanted to perform an aggregated calculation on a LastName field,you would use the ________ function.
A)Sum
B)Count
C)Total
D)You cannot perform aggregated calculations on text fields.

Question

Quizplus · Accepted Answer

The Count function is used to perform aggregated calculations on fields that contain text or numerical values. The Sum function is used for numerical values only. The Total function does not exist in SQL. Option D is incorrect as you can perform aggregated calculations on text fields using the Count function.

If You Wanted to Perform an Aggregated Calculation on a LastName