1.11.2 Example 2: Determine the number of people who purchased a product
Determine the total number of people in the sales history table (SALESLIST) who purchased the product of product code P003 on or after September 5, 2011.
- Table to search
- Specification example
-
SELECT COUNT(*) FROM "SALESLIST" WHERE "PUR-DATE">=DATE'2011-09-05' AND "PUR-CODE"='P003'
- Retrieval results