How do I look up earliest date value?

I have data that tracks the history of the value of a field. The columns are ParentId, FieldName, Date, Value. I want to find the first value, the value with the earliest date, with a given set of...