|Built-in Functions / Standard Built-in 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