Sam OZ

<div>
<div class="content wysiwyg-content fr-view">
I have a table in Sql server 2018 &nbsp;TB_Login &nbsp;( This is another application login details not Sql server login)&nbsp;<br>UserID &nbsp; &nbsp; &nbsp;LoginMonth<br>UserID1 &nbsp; &nbsp; &nbsp;202103<br>UserID1 &nbsp; &nbsp; &nbsp;202103<br>UserID2 &nbsp; &nbsp; &nbsp;202103<br>UserID3 &nbsp; &nbsp; &nbsp;202104<br>UserID1 &nbsp; &nbsp; &nbsp;202104<br>UserID3 &nbsp; &nbsp; &nbsp;202104<br>UserID4 &nbsp; &nbsp; &nbsp;202104<br><br>......<br><br>How can I get the unique count of users per month ? &nbsp;In this case result is<br>202103 &nbsp; &nbsp; &nbsp; 2<br>202104&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;&nbsp;<br><br>
</div>
</div>



I have a table in Sql server 2018  TB_Login  ( This is another application login details not Sql server login) 
UserID      LoginMonth
UserID1      202103
UserID1      202103
UserID2      202103
UserID3      202104
UserID1      202104
UserID3      202104
UserID4      202104
......
How can I get the unique count of users per month ?  In this case result is
202103       2
202104       3  

Sql script for Sql server - Get unique user login count from a custom login table

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.