Link to home
Create AccountLog in
Avatar of Wayne Burr
Wayne BurrFlag for United States of America

asked on

Query to group and sum multiple ID's

I have run aground on creating a Query to Sum up values in a month and by a Employee ID.  There are multiple columns that hold values but they all should be summed by for the month and by Employee ID.
I have included what I have but based on a where clause for 1 employeeID but there can't be a condition for just one employeeid, the query has to group by the employeeID placing all summed values for that employeeID in the appropriate month etc.
uggg.
Any help would be awesome.
**The screen is from a PostGreSQL screen, but the query syntax is what I am looking for in SQL Server etc**
groupAE-IDsQuery.jpg
ASKER CERTIFIED SOLUTION
Avatar of rstomar
rstomar

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Wayne Burr

ASKER

(Group by) - Man, talking about missing it :)  It's time to just walk away.
Thanks a bunch!