[SOLVED] SUM of Returned Column Values

[bubbadawg]

I have the following query:

SELECT DISTINCT project, SUM(hours) as Hours FROM `projects_tbl` GROUP BY project

 

This returns data similar to the following:

project         Hours
dev#1          5
dev#2          15
dev#3          12
dev#4          8
dev#5          10

 

How can I get the sum of all the Hours (50) from all the projects in the returned query?

 

Thanks for any and all replies.

[Zane]

going out on a limb here but maybe

 

SELECT SUM(hours) as Hours FROM `projects_tbl` GROUP BY project

[fenway]

Add "WITH ROLLUP" to your group by.

 

Aside: Drop the DISTINCT.

[bubbadawg]

Add "WITH ROLLUP" to your group by.

 

Aside: Drop the DISTINCT.

 

Thanks, that did it! The resulting total is returned with a NULL value for the row name. Is it possible for me to set a name for the row?

[fenway]

Thanks, that did it! The resulting total is returned with a NULL value for the row name. Is it possible for me to set a name for the row?

You should be able to handle this trivially in PHP.

[bubbadawg]

 

Thanks, that did it! The resulting total is returned with a NULL value for the row name. Is it possible for me to set a name for the row?

 

For anyone who is interested, using COALESCE will supply the label, in this case 'Total' for the last row. Here's the complete query:

 

SELECT COALESCE(project,'Total')project, SUM(hours) as Hours FROM `projects_tbl` GROUP BY project WITH ROLLUP;

[fenway]

So will IFNULL().