Combine rows adding specific columns

Question

I have a table similar to the following:

employee_id | totalWorkHours | projectID
     1             20              123
     1             20              321

     2             15              222
     2             25              333

     3             10              434
     3             12              343

Is it possible to combine rows based on employee_id, but add totalWorkHours into an actual total for an employee and present in a result set without modifying the table?

So the results would be something like:

employee_id | actualTotalWorkHours
     1                 40
     2                 40              
     3                 22

Or is this something better done with the raw result set?

Any help is much appreciated.

George Mastros · Accepted Answer · 2011-05-25 23:16:36Z

2

Select employee_id, Sum(totalWorkHours) As actualWorkHours
From   YourTableName
Group By employee_id
Order By employee_id

answered May 25, 2011 at 23:16

George Mastros

24.6k5 gold badges56 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combine rows adding specific columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related