1.12.2 Example 2: Determine the sum of quantities purchased)
Determine the sum of quantities purchased (PUR-NUM) on September 6, 2011 for product code P002 in the sales history table (SALESLIST).
- Table to search
- Specification example
-
SELECT SUM("PUR-NUM") FROM "SALESLIST" WHERE "PUR-CODE"='P002' AND "PUR-DATE"=DATE'2011-09-06'
- Retrieval results