Database Tour Documentation Contents Index

Filter Examples

Top Previous Next

1. Select those records from the table "payments" where values of the numeric field "PAYSUM" are greater than 400 and less than 2000:

PAYSUM > 400 AND PAYSUM < 2000

2. Select those records from the table "books" where values of the numeric field "COST" are greater than 150:

COST > 150

3. Select those records from the table "goods" where values of the numeric field "COST" are not equal 150, and values of the string field "NAME" are conform with "Tea" or "Coffee":

cost <> 150 and (Name = 'Tea' or Name = 'Coffee')