Groups > microsoft.public.sqlserver.programming > #31385

Days of Week with Total

Newsgroups	microsoft.public.sqlserver.programming
Date	2023-10-12 01:10 -0700
Message-ID	<f2e353a4-d330-48a3-ab37-0c77f77f617an@googlegroups.com> (permalink)
Subject	Days of Week with Total
From	Russ Hromyko <rhromyko@gmail.com>

Show all headers | View raw

Here is my query:

(SELECT DayName(startdate), COUNT(1) 
FROM reservations 
WHERE MONTH(startdate) = 09 AND YEAR(startdate) = 2023
GROUP BY DayName(startdate)
ORDER BY DAYOFWEEK(startdate))
UNION ALL
SELECT 'Total' widgets, COUNT(1)
FROM reservations

The output is:

Friday		14
Saturday	6
Sunday		3
Thursday	6
Tuesday		1
Monday		5
Wednesday	2
Total		37

How do I make the output Sunday through Saturday with Total?

Sunday		3
Monday		5
Tuesday		1
Wednesday	2
Thursday	6
Friday		14
Saturday	6
Total		37

Back to microsoft.public.sqlserver.programming | Previous | Next | Find similar

Thread

Days of Week with Total Russ Hromyko <rhromyko@gmail.com> - 2023-10-12 01:10 -0700

csiph-web