I seldomly use SQL and I cannot find anything similar in my archive so I’m asking this simple query question: I need a query which one returns personID and only the first seenTime Records: Wanted result: That’s what I did & failed: P.S: Notice SQL CE 4 Answer If your seenTime increases as seenID increases: Update for another case: If