1.5.3 Example 3: Retrieve data conditioned on date of purchase and two product codes
Retrieve the customer ID (USERID), product code (PUR-CODE), and date of purchase (PUR-DATE) from the sales history table (SALESLIST) for customers who purchased a product whose product code is P001 or P003 on September 4, 2011 or later.
- Table to search
- Specification example
-
SELECT "USERID","PUR-CODE","PUR-DATE" FROM "SALESLIST" WHERE "PUR-DATE">=DATE'2011-09-04' AND ("PUR-CODE"='P001' OR "PUR-CODE"='P003')
- Retrieval results
- Note
-
If both AND and OR are specified, AND is evaluated first. To change the priority of evaluation, specify ( ) as in the specification example above.