有这样一张表，存放用户玩游戏的日志，现在要求查询只玩一种游戏的用户。 如下面表中应返回
uid
3
4
因为3只玩了王者荣耀， 4只玩了斗地主，这样的sql怎么写
解决方案
select uid from user_play_logs group by uid having count(distinct game) = 1
这条sql怎么写，查询只玩一种游戏的用户
2017-09-08 08:50:37 来源：网友分享
有这样一张表，存放用户玩游戏的日志，现在要求查询只玩一种游戏的用户。 如下面表中应返回
uid
3
4
因为3只玩了王者荣耀， 4只玩了斗地主，这样的sql怎么写
select uid from user_play_logs group by uid having count(distinct game) = 1