If I understood the question correctly, you could try something like:
SELECT *
FROM YourTableName A
WHERE A.Valid = 0
AND A.CameraEntry = (SELECT MAX(B.CameraEntry)
FROM YourTableName B
WHERE B.Valid = 0)
Note that the query above can return several rows if the same value can be repeated in
CameraEntry