Re: Count of distinct records

select count(distinct {tablenames})

Pete Kolton wrote in message <82ogs6$msg$1_at_supernews.com>...
>We have a table which contains duplicate records.
>
>Obviously we can do a select count(*)... of the records in the table, and
we
>can do a select distinct *... of the records in the table.
>
>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:52:10 CET