Results 1 to 2 of 2

Thread: Solve this Query

  1. #1
    Join Date
    Jun 2007
    Posts
    3

    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.

  2. #2
    Join Date
    Jun 2007
    Posts
    1
    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
  •