CODE EXAMPLE FOR SQL

sql server select last row of each item in group by column

select ID, Name FROM 
(select ID, Name, max(ID) over (partition by Name) as MAX_ID
from Customer) x where ID= MAX_ID