Max of Column B based on Column A

Question

I have a table with company names and their IDs. Some companies could have multiple IDs, so I want to create another table with the company names and maximum of the IDs (basically the latest created ID).

I have been able to get the company names in a new table and remove duplicates, so that each company name appears only once. However, I'm stuck at how to get the maximum ID from the other table into this one. Any help would be appreciated.