(Easy One) Using distinct 2

[Gatorajc]

I need a query that only selects certain projects from a table yet gets all the hours worked on it.

Project Hours
Help Desk 7
Help Desk 9
External 2
Reimage 1
Help Desk 1


I want to get only the Help Desk Project once yet get all the hours. I know there is something with distinct but have not been able to get it to work.
AJ
I would lose my head if it wasn't attached.

 

[karluk]

You can do this with a "group by" clause. Something like

select project, sum(hours) as total_hours from your_table
where project = 'Help Desk'
group by project

 

[r937]

>> "only the Help Desk Project once yet get all the hours"

all the hours individually?

select Project, Hours
  from yourtable
 where Project="Help Desk"

all the hours summed up?

select Project, sum(Hours)
  from yourtable
 where Project="Help Desk"
group by Project

rudy

 

[Gatorajc]

Thanks that worked AJ
I would lose my head if it wasn't attached.