I am very Sorry about that but i was bit worried with the query i was not getting, Thanks allot to every one, I got my answer and i have...

Sorry Jeff , That was my mistake i didnt give correct details,

Thanks allot for your valuable time

Thank you SSC Enthusiastic, I got it What i want

Execuse me

Since you did not understand i how given that data and more over i do not want to disclose my original data i have given that, if you...

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...