Which of the following function gives the total number of rows in a given column or expression?
(D) Both (a) and (b)
Checking the options
- (A) SUM() - It returns the total sum of a numeric column.
- (B) COUNT() - It returns the number of rows that matches a specified criterion.
- (C) TOTAL() - It is not an aggregate function in SQL.
- (D) Both (a) and (b)
From the above explanation, we understand that it is the COUNT( ) function which gives the total number or rows in a given column or expression.
So, the correct answer is (B)