New answers tagged distinct
0
votes
Selecting a count of distinct logins per day
select activitytime,sum(case when rk = 1 then 1 else 0 end) unique_users_count
from
(
select activitytime,[user_id],rank() over(partition by [user_id] order by activitytime) rk
from @Activity
) k
...
Top 50 recent answers are included