1.13.2 Example 2: Determine the number of sales for each product code
Determine the number of sales on or after September 5, 2011 for each product code (PUR-CODE) in the sales history table (SALESLIST).
- Table to search
- Specification example
-
SELECT "PUR-CODE",COUNT(*) FROM "SALESLIST" WHERE "PUR-DATE">=DATE'2011-09-05' GROUP BY "PUR-CODE"
- Retrieval results