Multiple choice

Which of the following returns the number of records in the result from a SELECT query?

  1. ADD()

  2. SUM()

  3. COUNT()

  4. TOTAL()

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The COUNT() aggregate function in SQL is used to return the number of rows that match a specified criterion. SUM() adds up numeric values, while ADD() and TOTAL() are not standard SQL aggregate functions for counting rows.

Keep practicing — related questions