Computer Science for IGCSE & O level - Databases (Section 4 - No. 3)

What does the SQL command `COUNT(*)` do?
Counts the number of distinct values in a column.
Counts the total number of rows in a table.
Counts the number of non-null values in a column.
Displays all values in all columns.

Explanation

`COUNT(*)` counts all rows in a table.

Comments (0)

Advertisement