count 6.5++

[Bernard Lis]

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.