Retrieving the last record in each group

select *
from comment as m1
left join comment as m2  on ( m1.id<m2.id and m1.vulnerability_id=m2.vulnerability_id)
where m2.id is null
;