Filtering, sorting, summing

[kbaisch]

Can someone help me with the syntax? I want to sum the hrs for each dept, name & ppe. Any help given will be much appreciated.
Thanks in advance.


Dept_# Name PPE Hrs
533 Empl Name 4/15/2006 0
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8

[ck9663]

Can someone help me with the syntax? I want to sum the hrs for each dept, name & ppe. Any help given will be much appreciated.
Thanks in advance.


Dept_# Name PPE Hrs
533 Empl Name 4/15/2006 0
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8

i believe GROUP BY is what you need...

-- ck

[ganeshkumar08]

Can someone help me with the syntax? I want to sum the hrs for each dept, name & ppe. Any help given will be much appreciated.
Thanks in advance.


Dept_# Name PPE Hrs
533 Empl Name 4/15/2006 0
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name 4/30/2006 8

Select Dept_#, Name, PPE, Sum(Hrs) from Table_Name Group By(Dept_#)