i have table similar to this:
ID | event | user | time | note | archived
I need the number of events that individual users have been to, but one user can have more than one record for one event, so I only need to count it once.
The result should look like this:
user | nrofevents
Thank you for any advice.
>Solution :
Possibly it’s just the use of distinct you need?
select user, count(distinct event) as nrofevents
from t
group by user;