Hi!
Think about using DISTINCT and COUNT together.
I don't think it is a best coice.
But maybe I'm wrong.
Please Paul Dubois make your point.
regards
On Wed, 22 Oct 2003 13:25:20 -0400, Hector Del Curto wrote
> I have this 2 queries:
>
> SELECT COUNT(DISTINCT(LEFT(p.prod_num,5))) FROM products
You're getting a distinct on just the prod_num in the first query, but
are requesting distinct prod_num, description, line, and content in the
second one: if any of those last three columns are different between
rows, you will see ones additional to the count you get in the first
query. You ei
