Which of the following functions counts the number of records that have a value in the field?
A)Avg
B)Sum
C)Count
D)Max

Question

Quizplus · Accepted Answer

The COUNT function is used to count the number of records in a database table or in a query result that have a value in a specific field. This function is commonly used to summarize data or to get a count of how many items qualify in a particular subset of data. The AVG function calculates the average value of a specified column or expression, the SUM function calculates the sum of a specified column or expression, and the MAX function returns the maximum value of a specified column or expression.

Which of the Following Functions Counts the Number of Records