starry_lucky的博客

背景： 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.