Group multiple rows with different column values to a single row
You should be able to get the desired result GROUPING BY student and getting max value of each subject.

You can find some examples of MAX function on TERADATA here or here.

SELECT   student as StudentID,
         MAX(maths) as Maths,
         MAX(physics) as Physics,
         MAX(chemistry) as Chemistry
FROM     student
GROUP BY student;