How can I get total of a table

[BizBoy]

Hi,
I am using below query to get details.

SELECT Designation, Count(Designation) AS Total
FROM Combine
WHERE MyDate = #5/7/2018#
GROUP BY Designation
ORDER BY Count(Designation);

This query gives me number of people for each designation from the table.
How can get sum of number of people for each designation.

Can anyone please help me in this.

 

[xenou]

Hi, since people are not numbers a count and a sum would be the same!

ex.
1, 2, 3 --> count is three and sum is 6
John, Sally, Mary --> count is three, and "sum" is also three.

 

[BizBoy]

Hi xenou,

Sorry for confusing you. I am getting correct counts by this query.
I am trying to get total people present in database.

For example, my database has 50 managers and 5 workers.
My query is giving correct result,
managers = 50
workers = 5

However I want to add total below these two.
So result will be something like this.

managers = 50
workers = 5
Total = 55

Have a nice day ahead.

 

[xenou]

You would need two queries:

SELECT Designation, Count(Designation) AS Total
FROM Combine
WHERE MyDate = #5/7/2018#
GROUP BY Designation
ORDER BY Count(Designation)

UNION ALL

SELECT 'Total' as Designation, Count(*) AS Total
FROM Combine
WHERE MyDate = #5/7/2018#

 

[BizBoy]

Hi xenou,

Thanks a lot for the help. Have a nice day ahead.

 

[xenou]

No problem, you are welcome.