Have an SQL query for DB2 that returns the timestamp of when an event completed. It completes at 2 different date/times, which is the result expected.
That result completes at those 2 different times for the same entity. I desire that the entity be counted one time for the purposes of my query.
How would I get the query to return the result for only the first instance of completion for that entity?