SQL：根据第一列取最多两列

I have three columns being returned Column one is a system generated "ID" column two is the warehouse and the third column is the total that warehouse shows on that ID. There are duplicate ID's Im trying to figure out how to take the max count of the Warehouse and get the greatest warehouse on that ID for example:I have three columns being returned Column one