How to get distinct logins for particular month in MYSQL?

Vote count:

0

I have a data like below, userid action login_month 2 login 1 2 login 1 2 login 1 5 login 3 5 login 3 9 login 7 9 login 7 I need output as unique logins per month like, userid action login_month 2 login 1 5 login 3 9 login 7 Can anyone please suggest for a solution in mysql.

asked 2 mins ago

Ram

1

How to get distinct logins for particular month in MYSQL?