Which function is used to calculate the total amount of a numeric column across rows?

Which function is used to calculate the total amount of a numeric column across rows?

• A. COUNT
• B. SUM
• C. MAX
• D. MIN

Answer: (B)

The operation you need is adding every numeric value in the column to get a single total. That’s exactly what the summation function does: it takes all the values in the column across rows and returns their arithmetic sum. So this is the best choice for calculating a total amount. Think of it like adding up all the sales amounts in a column to get total sales. The other options have different roles: one counts how many rows or non-null values there are, another finds the largest value, and the last finds the smallest value. In the presence of missing values, the sum typically ignores them, giving you the total of the existing numbers.

The operation you need is adding every numeric value in the column to get a single total. That’s exactly what the summation function does: it takes all the values in the column across rows and returns their arithmetic sum. So this is the best choice for calculating a total amount.

Think of it like adding up all the sales amounts in a column to get total sales. The other options have different roles: one counts how many rows or non-null values there are, another finds the largest value, and the last finds the smallest value. In the presence of missing values, the sum typically ignores them, giving you the total of the existing numbers.