You are reading a single comment by @Greenbank and its replies. Click here to read the full conversation.
  • Not sure I understand it completely, but what about taking min(starttime) and max(endtime) grouping by subject_id?

    select min(starttime),max(endtime),subject_id from dataset group by subject_id;
    

    Maybe some example data might help, can you come up with a simple case and a slightly more complex case?

About

Avatar for Greenbank @Greenbank started