Count of distinct records

From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Thu, 9 Dec 1999 15:14:42 -0000
Message-ID: <82ogs6$msg$1_at_supernews.com>

[Quoted] [Quoted] We have a table which contains duplicate records.

[Quoted] [Quoted] Obviously we can do a select count(*)... of the records in the table, and we [Quoted] can do a select distinct *... of the records in the table.

[Quoted] What we want to do is combine these two so that we get a count of the distinct records.

Any suggestions? Received on Thu Dec 09 1999 - 16:14:42 CET