Message
From
29/01/2017 14:57:07
Michel Fournier
Level Extreme Inc.
Petit-Rocher
,
New Brunswick
,
Canada
To
29/01/2017 14:55:04
Michel Fournier
Level Extreme Inc.
Petit-Rocher
,
New Brunswick
,
Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re:
COUNT(*) with GROUP BY
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows Server 2012
Miscellaneous
Thread ID:
01647119
Message ID:
01647120
Views:
36
I have found the OVER syntax. Not sure if this is the proper way:
SELECT
COUNT
(*)
OVER
()
AS
RecordCount
FROM
Client
WHERE
Client.Active=
1
GROUP
BY
Client.NoMember
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the
Level Extreme Platform
Subscribe to the site at
https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits
https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only