Here is the CORRECT ANSWER:
select  LogID
       ,IPAddress
       ,Creation_Timestamp
       ,Location
from TmpLog  A
where A.Creation_Timestamp 
 (select max(Creation_Timestamp)
   from TmpLog B
   where A.IPAddress = B.IPAddress  )

Regards
Yakov