Sum of Column

[macca]

I have a query and I want to get the overall Sum of the values returned for NumberDuplicates in below query:

SELECT FirstName, LastName, COUNT() AS NumberDuplicates
FROM CitizenContactJ
GROUP BY FirstName, LastName
HAVING (COUNT() > 1)
ORDER BY FirstName

anyone know how to do this?

[gbritton]

group by rollup(FirstName, LastName)

[madhivanan]

@macca

SELECT FirstName, LastName, COUNT() AS NumberDuplicatesFROM CitizenContactJGROUP BY FirstName, LastNameHAVING (COUNT() > 1)ORDER BY FirstName

You can try

SELECT SUM(NumberDuplicates) as NumberDuplicates
FROM
(
SELECT FirstName, LastName, COUNT() AS NumberDuplicates
FROM CitizenContactJ
GROUP BY FirstName, LastName
HAVING (COUNT() > 1)
) as t