-
Solve this Query
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.
-
select Roll Number ,greatest(Oracle,Vb,Java,SQL Server,Unix
) from marks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|