Bernie:
Try : select count (distinct orderno) from mlitmin
Jim
At 03:41 PM 9/5/02 -0400, you 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.
========================================
Jim Schmitt
Ohio Software Services
2211 Lake Club Drive
Columbus, Oh 43232
Phone 1-614-863-1850
Fax 1-614-863-0325
E-mail [EMAIL PROTECTED]
========================================
================================================
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/
