Cross Join

SELECT tt.StudentId, tt.ChangedTime, tt.SubjectId
FROM StudentResults_Log tt
INNER JOIN
    (SELECT StudentId, MAX(ChangedTime) AS MaxDateTime
    FROM StudentResults_Log
    GROUP BY StudentId) groupedtt
ON tt.StudentId = groupedtt.StudentId
AND tt.ChangedTime = groupedtt.MaxDateTime