Sql query..... Sum of another aggragate function

[Coool.Net]

SELECT Category, COUNT(Labour_ID) AS LabourCount FROM
HR_Labours
WHERE (Absconded = '0') AND (VisaCancelled = '0') AND (OnLeave =
'0') AND (Terminated = '0')
GROUP BY Category




here i reading count of labours under this criteria .... as lzbour
count ..for each category...but
i need the total count means SUM of labourcout[LabourCount ] ...

i can i write this as SUM(count(Labour_ID))
or ho i will get the sum...
plz help me

 

[Cor Ligthert [MVP]]

Philip,

As I understand you right, with a command.executescalar

http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbcommand.executescalar(VS.80).aspx

I hope this helps,

Cor