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(*)
The resulting data type is INTEGER.
-- Count the number of rows in the Flights table SELECT COUNT(*) FROM Flights
Scripting on this page tracks web page traffic, but does not change the content in any way.