C'mon, David, details, details, details ... but, umm, good eye! Later, Steve in Memphis ----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 5:37 AM Subject: Re: Counting Groups - 6.5+
> SELECT ZipCode, Count (ZipCode) GROUP BY ZipCode > > Looks like no one read the original message carefully - the original request > was to get counts IN ORDER FROM MOST FREQUENTLY USED TO LOWEST: > > So you need: > > SELECT ZipCode, Count (*) GROUP BY ZipCode ORDER BY 2 DESC > > The "2" refers to the "second item after the SELECT command", which in this > case is the count > > David Blocker > > ----- Original Message ----- > From: "Lawrence Lustig" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, September 26, 2002 12:10 PM > Subject: Re: Counting Groups - 6.5+ > > > > << > > I also tried a SELECT ZipCode, Count (ZipCode) GROUP BY COUNT > (ZipCode).... > > and also received an error message. > > > > Any suggestions? > > >> > > > > SELECT ZipCode, Count (ZipCode) GROUP BY ZipCode > > > > -- > > Larry > > > > > > ================================================ > > 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/ > > > > > ================================================ > 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/ ================================================ 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/
