Multiple choice technology databases

How can we get the number of records or rows in a table?

  1. Using COUNT

  2. Using NUM

  3. Using NUMBER

  4. Both a and c above

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

SQL uses the COUNT aggregate function to return the number of rows in a table, either as COUNT(*) or COUNT(column_name). NUM and NUMBER are not valid SQL aggregate functions.