remove historical data from table

Hi,  I am facing issue in creating Table 2 from Table 1. Table 1 has historical records for the host. I want to keep the latest row data for each host in Table 2.   please refer Table 1   Hos...