Question

In SQL, the aggregate function which will display the cardinality of the table is ______.

Options

• sum()

• count(*)

• avg()

• sum(*)

Answer 1

In SQL, the aggregate function which will display the cardinality of the table is count(*).

Explanation: 

A table's cardinality is its number of rows, which is returned by count(*) from the statement.