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
- Specification example
-
SELECT COUNT(*) FROM "USERSLIST"
- Retrieval results
Hitachi Advanced Database SQL Reference
1.11 Determining the number of retrieved data items (COUNT(*))
1.11.1 Example 1: Determine the total number of customers
Determine the total number of customers in the customer table (USERSLIST).
SELECT COUNT(*) FROM "USERSLIST"