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

Reply via email to