Skip to content
Advertisement

Tag: sql-server-ce-4

SQL: Return only first occurrence

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

Advertisement