Bernie, Try it with fewer parentheses, using the format in the syntax diagram:
SELECT COUNT (DISTINCT orderno) FROM mlitmln Bill On Thu, 05 Sep 2002 15:41:23 -0400, Bernard Lis wrote: >sel count(distinct(orderno)) from mlitmln >gives error col count not found > >sel distinct(count(orderno)) from mlitmln >ignores the distinct and just counts all the rows. > >so how can I count the number of orders in this table? >(the same orderno can occur many times) > >Bernie Lis >Megabytes, Inc. > ================================================ 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/
