计算Group by分组后的个数 select count(*) from (select GameScore.gameid from GameScore where GameScore.Username <> '' Group by GameScore.Username, GameScore.gameid) as a;