apache > db
Apache DB Project
 
Font size:      

COUNT(*)

COUNT(*)

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.

Syntax

COUNT(*)

The resulting data type is BIGINT.

Example

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


Previous Page
Next Page
Table of Contents
Index