Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before:
SELECT min(Parsed.Time), [Parsed.Number]
FROM Parsed
GROUP BY [Parsed.Rev Number]