Home Forums SQL Server 2014 Administration - SQL Server 2014 To get the average of two largest number amount three column for particular identity. RE: To get the average of two largest number amount three column for particular identity.

  • May 3, 2015 at 12:49 pm

    #1795255

    Uday3421 (5/3/2015)

    ID A B C AVG

    ------------------------

    1 08 09 10 -

    ------------------------

    2 10 25 26 -

    ------------------------

    3 09 15 16 -

    ------------------------

    Friends,

    I want to calculate the average of the larges two number from the column A,B & C for particular identity and store that average in the AVG column,

    PLz help me out.......

    Thank you.

    what are your expected results from this?

    can you show us what you have tried so far?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day