Sum values in Column B where unique Value in Column A
630617Apr 29 2008 — edited Apr 29 2008Hi all,
I need help with a SQL query but first let me give some background information. I have a view that lists a series of projects and all instances in which hours were billed to that project. Selecting all rows from this view returns 11, 490 rows but selecting unique project numbers from the table only returns 771 rows due to the fact that the view was created to list all instances in which hours were billed to each project. How can I create a SQL statement that will sum the cost for each project returning only the unique 771 rows? any help would be greatly appreciated. Thanks.