kev510
Programmer
- Jul 12, 2006
- 61
hello everyone,
I have been trying to figure this out for the last 45 minutes... Finally, I gave in and decided to post here. To summarize, I have a table with 2 fields. I need to pull the maximum count of field B, with its corresponding field A value. I tried the below -
select max(count(b)), a from TABLE group b, a
but i keep getting error "not a single-group group function".
Thanks in advance for your help!
I have been trying to figure this out for the last 45 minutes... Finally, I gave in and decided to post here. To summarize, I have a table with 2 fields. I need to pull the maximum count of field B, with its corresponding field A value. I tried the below -
select max(count(b)), a from TABLE group b, a
but i keep getting error "not a single-group group function".
Thanks in advance for your help!