1.5.1 Example 1: Retrieve data conditioned on date of purchase

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 on September 6, 2011 or later.

Table to search

Specification example

SELECT "USERID","PUR-CODE","PUR-DATE"
    FROM "SALESLIST"
        WHERE "PUR-DATE">=DATE'2011-09-06'

Retrieval results

Note

• When specifying search conditions in the WHERE clause, you can use the comparison operators listed below. The following table lists the comparison operators and their meanings.

  Table 1‒1: Comparison operators and their meanings

  No.	Comparison operator	Meaning
  1	=	equal to
  2	<>, !=, or ^=	not equal to
  3	<	less than
  4	<=	less than or equal to
  5	>	greater than
  6	>=	greater than or equal to

• If the value specified in the conditional expression is a CHAR type or VARCHAR type character string, enclose the value in single quotation marks (').

  Example: WHERE "NAME"='Taro Tanaka'

• If the value specified in the conditional expression is a date of type DATE, specify it in the following manner.

  Example: WHERE "PUR-DATE">=DATE'2011-09-06'

To Page Top