Re: Count of distinct records
From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Fri, 10 Dec 1999 09:33:33 -0000
Message-ID: <82qh8h$3fe$1_at_supernews.com>
Date: Fri, 10 Dec 1999 09:33:33 -0000
Message-ID: <82qh8h$3fe$1_at_supernews.com>
Thomas and Geoff,
Thanks guys - that's the one I was looking for.
> SELECT COUNT(*) FROM (SELECT DISTINCT * FROM MYTABLE);
Received on Fri Dec 10 1999 - 10:33:33 CET