Selection

Inspections for the year 2000.

 

Period= 2000 (Inspection)

Inspection RegNo DateInspected Period Evaluation
  ABC123 2000-01-03 2000 OK
ABC123 1999-01-15 1999 OK
DFG456 2000-12-04 2000 FAIL
HIK123 2000-10-20 2000 OK
TOP111 2000-05-11 2000 OK

 

In the second tuple of Inspection the value of attribute Period is not equal to 2000. Thus the selection condition is false and the tuple will not be included in the result.
Inspection RegNo DateInspected Period Evaluation
  ABC123 2000-01-03 2000 OK

NextFrame