1.1

Example
-- Count the number of countries in each region,
-- show only regions that have at least 2
SELECT COUNT (country), region
FROM Countries
GROUP BY region
HAVING COUNT (country) > 1
COUNT(*) function
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 INTEGER on page 609.
Example
-- Count the number of rows in the Flights table
SELECT COUNT(*)
FROM Flights
CURRENT DATE function
CURRENT DATE is a synonym for CURRENT_DATE function on page 552.
CURRENT_DATE function
CURRENT_DATE returns the current date; the value returned does not change if it is executed more than once
in a single statement. This means the value is fixed even if there is a long delay between fetching rows in a
cursor.
Syntax
CURRENT_DATE
or, alternately
CURRENT DATE
Example
-- find available future flights:
vFabric SQLFire User's Guide552
vFabric SQLFire Reference