SQL Query........... [Resolved]

Hi All,

I have a table named Student with columns StudId, Subject, Marks.

1 maths 65
1 English 90
1 Social 55
1 Kannada 60
1 Computer 85
2 maths 55
2 English 63
2 social 55
2 Kannada 90
2 Computer 70
3 Maths 80
3 English 30
3 Social 75
3 Kannada 60
3 Computer 45

I want to find the highest of marks of each student in subject.
i.e O/P should be like this

1 English 90
2 Kannada 90
3 Maths 80


Please help me...

-Somu [Resolved]