K
Kostas Arvanitidis
Hello,
I have a table:
Table1
[cityID] [clientID] [company] [percentage]
1 1 xxy 23
1 2 xxv 12
2 1 sss 11
2 3 aaa 3
I need to make a query that exports a result like this:
[clientId] [numberoftoppercent]
1 2
2 0
3 0
To explain, i want to count that client '1' topped in 2 cities, client '2'
in '0' etc.
Any help please?
I have a table:
Table1
[cityID] [clientID] [company] [percentage]
1 1 xxy 23
1 2 xxv 12
2 1 sss 11
2 3 aaa 3
I need to make a query that exports a result like this:
[clientId] [numberoftoppercent]
1 2
2 0
3 0
To explain, i want to count that client '1' topped in 2 cities, client '2'
in '0' etc.
Any help please?