Filter Examples - Database Tour Documentation

Select 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
```
Select records from the table books where values of the numeric field COST are greater than 150:
```
COST > 150
```
Select records from the table goods where values of the numeric field COST are not equal 150, and values of the string field NAME match to Tea or Coffee:
```
cost <> 150 and (Name = 'Tea' or Name = 'Coffee')
```