Hello Friends,

Can we search maximum records in the coloumn wise.

suppose i have a table having coloumn RollNumber,Oracle,VB,java,SQL Server,Unix

now if i want to find the maximum marks in a subject for each student how can i get


Roll Number Oracle Vb Java SQL Server Unix
1 85 70 74 65 60
2 70 56 44 80 71

output should be

1 85
2 80


Reply me
Thanks in advance

Regards
Harsh.