sele latest entry for a group of records

[Kong, Alan]

This may work for you if I understand your question correctory.
 
Select id, location, updated_date from tape where rowed = (select max(rowed)
from tape group by id, location, trunc(updated_date));