|
Greetings folks.
I'm trying to write a line of code which displays
unique data from a text column (zipcodes), followed by a count of each row,
and ordered from highest to lowest. I've tried TALLEY, which works except that
it's not ordered. I've also tried a SELECT DISTINCT (ZipCode), COUNT (ZipCode),
but am told the command is illegal. I also tried a SELECT ZipCode, Count
(ZipCode) GROUP BY COUNT (ZipCode).... and also received an error
message.
Any suggestions?
Thanks,
Dan
|
- Windows XP SP1 - Control Enter doesn't work. Kenny Camp
- Re: Counting Groups - 6.5+ Dan
- Re: Counting Groups - 6.5+ Bernard Lis
- Re: Counting Groups - 6.5+ J. Stephen Wills
- Re: Counting Groups - 6.5+ Bill Downall
- Re: Counting Groups - 6.5+ Lawrence Lustig
- Re: Counting Groups - 6.5+ David M. Blocker
- Re: Counting Groups - 6.5+ J. Stephen Wills
- RE: Counting Groups - 6.5+ Rommel Relosa
- Re: Counting Groups - 6.5+ David M. Blocker
