How to get only one user name for the same game

gosaga20's profile image gosaga20 posted 1 year ago in General Permalink

Good afternoon. is there a way to only get one username per game ID? Like when i want to get the total username who played coin toss but no duplication for example

Edward plays total of 4 games in coin toss but i want in my outcome Edward only Count as 1 ?

Thank you.

1 attachment(s):
  • Screenshot_2
ansgar's profile image ansgar posted 1 year ago Permalink

You need to use a GROUP BY Username, GameID clause in your query.

Please login to leave a reply, or register at first.