I have a query which returns count of particular type. And i need to get the all count types total at the bottom.
here is the query
SELECT a.Type, COUNT(DISTINCT b.ID)
FROM emp a
LEFT OUTER JOIN dept b
ON b.Name LIKE '%.' + a.Type
GROUP BY a.Type
and here is the sample result set.
And i wanted to include a row say Total
I wanted to see the result set like this
Any help is greatly appreciated.
Thanks in advance.