• Well if you include the start date in the group by, it'll output a row per different start date.

    So it's working the way it's supposed to work ...

    To resolve your problem, remove start date from the group by and do a max(startdate) in your select.