Whatever the value is for that row that has the max(discharge_dttm).

Thanks again

Hi Rubes,

I also need to select LogType which is not part of group by clause.

Thanks

Thank you Rowan. It solves my issue.

Can you explain how a view will get it done?

Thanks