SELECT COUNT(DISTINCT orderno) FROM mlitmln DISTINCT is not a 'parenthetical' function.
Bernard Lis <[EMAIL PROTECTED]> 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. > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
