COUNT(*) function

COUNT(*) function COUNT(*) is an aggregate function that counts the number of rows accessed. No NULLs or duplicates are eliminated. COUNT(*) does not operate on an expression. COUNT(*) aggregate function

See for more information about these functions.

SyntaxCOUNT(*)

The resulting data type is INTEGER.

Example -- Count the number of rows in the Flights table SELECT COUNT(*) FROM Flights