Hitachi

Hitachi Advanced Database SQL Reference


1.11.1 Example 1: Determine the total number of customers

Determine the total number of customers in the customer table (USERSLIST).

Table to search

[Figure]

Specification example
SELECT COUNT(*)
    FROM "USERSLIST"
Retrieval results

[Figure]