Dan: Give this a whirl:
SELECT ZipCode, COUNT(ZipCode) from <tablename> GROUP BY ZipCode ORDER BY 2 DESC -----Original Message----- From: Dan [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: Counting Groups - 6.5+ 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 ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
