none
Query to Summarize

    Question

  • Hi All,

    I have a table with detailed records in a table.

    For example,

    col1 col2 col3 col4 benefit
     
    1236  30  Peter Samuel 40.00
    1236  30  Peter Samuel 50.00

    I want to summarize the single value col1 whose one single records 1236 and sum of the benefit like 90.00

    This should be applied for the entire table.  Also, I need all the columns in the result set.

    Any help!!!

    Regards,
    kccrga

    Tuesday, September 24, 2013 10:45 PM

Answers

All replies