Thank you, But Sorry I didnt Get my result with that

My table is

Student

StudentID int,

name varchar(20),

maths int,

science int,

comp int

records are

1, Allen, 60, 80,75

2, John ,70,60,90

3, Kim, 86,85, 80

result should be

Allen science

John comp

Kim maths

Thank you