The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.
A) COUNT
B) MIN
C) MAX
D) SUM

Question

Quizplus · Accepted Answer

The COUNT function is used to count the number of rows in a particular column. It returns the number of rows containing non-null values for the given column. The other aggregate functions (MIN, MAX, SUM) do not provide this functionality.

The SQL Aggregate Function That Gives the Number of Rows