kunguito
09-03-2008, 03:36 AM
I have a single table Called MachineRevision.
The Fields of this table are:
Model: A reference code of the machine.
Revision: what was done to the machine (not relevant to the question)
Date: when was revised for the last time.
I need a SQL statement that retrieves which model was revised on the nearest date to a parameter date.
The Fields of this table are:
Model: A reference code of the machine.
Revision: what was done to the machine (not relevant to the question)
Date: when was revised for the last time.
I need a SQL statement that retrieves which model was revised on the nearest date to a parameter date.