SELECT channel,game_id,count(*) AS more_positive_user FROM (
SELECT channel,game_id, user_id FROM netgame_platform_log_login_user WHERE date='2014-12-30'
GROUP BY channel,game_id, user_id HAVING count(*)>=5
) AS a GROUP BY channel,game_id新手求教能实现上面查询的更加高效简单的sql语句~
SELECT channel,game_id, user_id FROM netgame_platform_log_login_user WHERE date='2014-12-30'
GROUP BY channel,game_id, user_id HAVING count(*)>=5
) AS a GROUP BY channel,game_id新手求教能实现上面查询的更加高效简单的sql语句~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货