Multiple choice technology databases

Which of the following aggregate functions returns a row count as an integer?

  1. (a) AVG

  2. (b) COUNT

  3. (c) STDEV

  4. (d) COUNT_BIG
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SQL aggregate function COUNT returns the number of rows as a standard integer (INT). COUNT_BIG functions similarly but returns its count as a BIGINT data type, while AVG and STDEV calculate averages and standard deviations.

Keep practicing — related questions