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