泠冷 发表于 2015-1-5 11:16:58

求教sql

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；


新人求教一个实现上面查询，更加高效简单的语句~


nycle 发表于 2015-1-13 23:24:14

建议进行细化拆分，逐个分析优化。
页: [1]
查看完整版本: 求教sql