I want to select the latest record for each loc_id

Below given is the screen shot of the thing i was working . i want to select the latest record for each loc_id(7,960,1152) i can't use top as it will select the top most record only and that even for the single store