This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hello,
I have a table which has daily datetimestamp and loginID
I would like to get a count of the LoginID for each month. How can I do this please?
Timestamp LoginId
2020-12-11T15:01:54.201000+00:00 B22
2020-12-11T15:32:36.403000+00:00 A5
...
Thank you
Can you provide some sample data scripts and excepted output for an input?
But based on your ask, the below query can work assuming you want it for month only irrespecctive of year:
Select count(*),Id,Month(TimeColumn)
Group by Id,Month(TimeColumn)
SELECT convert(char(6), Timestamp, 112), LoginID, COUNT(*)
FROM tbl
GROUP BY convert(char(6), Timestamp, 112), LoginID