Now I am using MySQL 5.7, I have some data like this:
user_id 63763 63763 NULL 16459,16535,16613,16615,42896,42911,62463,62464,63594,63763,63764,63765,63766,63769,63930,63934,63935 NULL NULL
I want to concat the user_id and distinct , finnally count the result of distinct result(finally I find the result still have duplicate value), is it possible to complete it in one sql? I known distinct like this:
select group_concat(DISTINCT user_id SEPARATOR ',') from report_summary where statistic_time >= 1615824000000
how to count the result?
and now I found the result still have duplicate value using this sql:
select group_concat(DISTINCT bet_user_ids SEPARATOR ',') from report_summary where statistic_time >= 1616083200000 and statistic_time <= 1616169599999
the result is:
42890 have three times in the result.