背景:
tag_table表中,共有10种tag,每个用户会有很多个tag标签
- 统计每个用户有多少种标签
SELECT user_id,count(*) FROM
(SELECT user_id,tag_id
FROM tag_table
GROUP BY user_id,tag_id
ORDER BY user_id)t
GROUP BY user_id
ORDER BY COUNT DESC
注:
(SELECT user_id,tag_id
FROM tag_table
GROUP BY user_id,tag_id
ORDER BY user_id)t
中 t 必不可少