Which of the following function gives the total number of rows in a given column or expression?
(A) SUM()
(B) COUNT()
(C) TOTAL()
(D) Both (a) and (b)
Answer:
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)