WITH CTE AS

(SELECT *, row_number() over (partition by unit order by id desc) as rowno

from tablename

)

select * from CTE where rowno=1;