In an SQL query,which built-in function is used to compute the number of rows in a table?
A)AVG
B)COUNT
C)MAX
D)MIN
E)MEAN

Question

Quizplus · Accepted Answer

The built-in function COUNT is used to compute the number of rows in a table. It returns the number of rows that match a specific condition, or all the rows in the table if no condition is specified. AVG calculates the average value of a selected column, MAX returns the maximum value in a selected column, MIN returns the minimum value in a selected column, and MEAN is not a valid SQL function.

In an SQL Query,which Built-In Function Is Used to Compute