Frequency of a value

  • Thread starter Kostas Arvanitidis
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top