I guess category (i.e. grouping field) is jobid, right?


>The standard way in SQL to find the data that corresponds to MIN/MAX is to use a correlated sub-query.
>
>The example I have is:
>
>

>select
>  jobid,
>  status,
>  supervisorid
> from jobprogress m
> where statusdate =
>  (select max(statusdate)
>   from jobprogress
>   where jobid = m.jobid)
>

>
>
>The is the typical way to select 1 row for a given ID if there are multiple rows for each ID with a date for each row.
>
>PF