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.
