|
masterdineen
Aged Yak Warrior
United Kingdom
518 Posts |
 Posted - 03/07/2013 : 10:16:10
|
Hello there.
Have a table with
customer_Id, gameName,
I want to select a distinct count for each game name,
at the moment I have have the following that will give me a total count for each game name.
But how do I count distinct customer id for each game name.
select game_name, COUNT (customer_id) from dbo.games
group by game_name
Regards
Rob |
|
Distinct count for ticket count
