locked
formula help RRS feed

  • Question

  • User-883911775 posted

    Hello. I am needing some help combining the following:

    RW1 Rig Welder 47 
    RW1 Rig Welder 60 
    RW1 Rig Welder 11 

    I need it to combine same class and description and sum the hours.

    RW1 Rig Welder 118

    Is this possible?

    Thursday, March 24, 2016 5:58 PM

Answers

  • User1578460427 posted

    SQL query:

    SELECT id, description, SUM(hours)
    FROM your_table_name
    WHERE id = 'RW1'
    GROUP BY id;
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 28, 2016 9:27 AM