|SQL Language Reference / Functions|
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.
The resulting data type is INTEGER.
-- Count the number of rows in the Flights table SELECT COUNT(*) FROM Flights