Group multiple rows with different column values to a single row I have 3 records with 3 column values for the same key.
PFB sample data.

CREATE TABLE student
(
    student varchar(100),
    maths int,
    physics int,
    chemistry int
)
PRIMARY INDEX (student)
ON COMMIT PRESERVE ROWS;

INSERT INTO student('Student_100', 90,   ,   );
INSERT INTO student('Student_100',   , 80,   );
INSERT INTO student('Student_100',   ,   , 70);


Now, for student_100, there are 3 records with 3 column values. 
I want to get output like below

StudentID   | Maths | Physics | Chemistry
------------+-------+---------+----------
Student_100 |  90   |   80    |    70


A single record with all column values. I don't want to use SUM function, because I have columns with Date type as well. So I am looking for a solution that fits all datatypes.
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;